Element Functions Added By Shilpan On Monday, January 16th, 2017 at 2:04 am You can use element functions in your set analysis expression to implicitly specify an element list. You can use either P() for possible values in a given field or E() for excluded values in a given field or combination of both P() and E() to create a set of intersection, union or exclusion. Let’s think […] READ MORE →

QlikView Set Analysis: Online Training Added By Shilpan On Wednesday, December 21st, 2016 at 4:38 am   Set Analysis is one of the most powerful advanced aggregation functionalities you can leverage as a QlikView or Qlik Sense developer. As a QlikView or Qlik Sense developer, you often need to create sub set of data independent of how users make selections. Simply put, QlikView and Qlik Sense empowers you as a developer […] READ MORE →

QlikView Variables Added By Shilpan On Wednesday, November 30th, 2016 at 4:39 am QlikView variables are useful as they provide ease of future script maintenance. A variable holds either a single numeric or string value. Back to basics You can define a QlikView variable by using SET or LET keywords in your script. SET assigns a string on the right-hand side of the equal to the variable LET […] READ MORE →

Set Analysis: Useful Tips Added By Shilpan On Wednesday, September 14th, 2016 at 12:51 am Set Analysis is one of the most powerful features at your disposal as a QlikView developer. Even beginner QlikView developer should learn basics of Set Analysis as it allows you to create a set independent of user selections. That said, set modifier is the most powerful catalyst within your set expression. Set modifier is akin […] READ MORE →

Set Analysis Added By Shilpan On Sunday, July 31st, 2016 at 11:38 pm Set Analysis is essential to create advanced aggregation formulas either in QlikView or Qlik Sense. Once you master basics of Set Analysis, you are on your way to create sets that are independent of user selections. Or to use data returned by a bookmark even when bookmark is not activated. This is powerful as now […] READ MORE →