Useful QlikView Resources

Some useful links available online

Tutorial for beginners
https://www.udemy.com/qlikview-for-beginners-by-techstuffy/


Some awesome QV blogs
https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/22/the-qlikosphere-external-resources--part-i


Best Practices for Data Modeling
https://community.qlik.com/servlet/JiveServlet/download/885320-190375/Best%20Practices%20Data%20modeling%20in%20QlikView.pptx



Best Practices Guidelines: Development book at
https://community.qlik.com/docs/DOC-4556


QlikView 11 Developer Tutorial (Very comprehensive)
https://community.qlik.com/docs/DOC-7364


QlikView Resource Library : Very good materials are available in QlikView website @ http://www.qlikview.com/us/explore/resources


YouTube QlikView Learning Channel - "QlikView on YouTube" : A lot of very informative videos are available @ http://www.youtube.com/user/qlikview/videos

Optimization at Script Level

Here are some performance optimization tips for QlikView scripting.


1. Remove unused fields. No use loading them and taking up precious server resources!

2. Do not use LOAD *;
This is difficult to debug and maintain especially when you change your table structures..

3. Do optimized load from QVD as UNoptimized load takes up more memory.

4. Use integers to join tables where possible. Or convert the string keys to integer using autonumberhash128 at script level. Numeric fields take up less memory than Strings.

5. Remove unused snowflake tables

6. Eliminate small “leaf” tables by using Mapping Load to roll code values into other dimensions or fact tables.

7. Eliminate Count(Distinct x)’s. They are very slow

8. Move as much business logic to the database server.

Optimization on User Interface

Most of the time, your users would be spending time navigating the user interface or the dashboard. Besides having a beautiful dashboard, it is important to have a responsive one.

Here are some best practices for a lean mean dashboard.

1. Do not use Calculated Dimensions anytime- It is good idea move this to the data model script and create those dimensions there. Calculate or derive those dimensions in your LOAD scripts.


2. Do not use Set Analysis against large data sets. Minimize using it for normal data sets.


3. Do not use long expressions. If you can simply them or use constant to reduce calculations, do it.


4. Do not use Count Distinct too often. Use it very cautiously!


5. Avoid using Macros – Macros should only be used for approved Reporting need, and any special circumstance.


6. Avoid using nested if statements


7. Reduce the numbers of Sheets and objects in the QVW app.


8. Do not have too many opened Chart objects in a sheet. Try using hiding charts not needed all the time.


9. Use conditional calculations on charts with large charts

Hello World!

This first entry is not going to show you how to print Hello World using QlikView. :p

I have been doing a QlikView development for awhile now and I notice I've been repeating myself every time I conduct training for junior team members. Why not just compile them online and point them to a FAQ! So here it is! Hope anyone who is interested in QlikView will benefit as well.

So Hello world!