Thursday, 28 August 2014

Qlikview Set Analysis and Point in Time Reporting

Qlikview's one of the most beautiful and hard to implement feature is Set Analysis functionality without any doubt. As long as it is implemented efficiently customer satisfaction tend to increase whilst in case of excessive and ineffective usage it is inevitable to have performance issues.

Qlikview professionals those creating applications for a long time came up with a good idea which lets you implement set analysis functionalities in an effective and reusable way. Miguel Garcia shared this in a series of blog post.

The method Mike suggests includes using Sequence Numbers, Clear Variable and Set Variables.
With the help of sequences and variables your set expression will get shorter and shorter and plus, by saving the script generating this functionality in a text file, you will be able to reuse it in your future projects.

I read through these posts and started to implement the idea on our project and now progressing faster.

Miguel Garcia is the co-author of the book "Qlikview 11 for Developers".

You can reach the related blog posts from the below links

The Magic of Set Analysis - Introduction
The Magic of Set Analysis - Syntax and Examples
The Magic of Set Analysis - Part III
The Magic of Set Analysis - Point in Time Reporting
Point in Time Reporting Out of the Box

A few notes regarding Set Analysis:

  • The excessive use of Set Analysis in chart expressions can yield poor performance or long response times. However, when used effectively, it can have a positive impact on both performance and user experience.
  • Number based comparisons are faster than text based comparisons.

Lastly, If you would like to extend your knowledge about Set Analysis, I suggest you to take Set Analysis course on Q-on Training Centre.

I hope it helps in your projects as well.

Please comment below to share your ideas about this topic.

Enjoy your work!

No comments: