Hello Qlik Users!
If you are on the Qlik Sense App Development forum or the QlikView App Dev forum, you might see some very seasoned developers writing line after line of code. You might be asking yourself, “what does all this mean!?” It can look intimidating.
One of the possibilities, is that the code is for Set Analysis.
Set analysis gives you a way to define a set or a group of values that is independent of any selections. It is commonly used for making comparisons (e.g. this year vs last year). With set analysis, you use set expressions to analyze data.
Set expressions are how you define the field values. A set expression must be used in an aggregation function (like sum) and it must be enclosed by braces, {}. The expression consists of operators, identifiers and modifiers.
Here are some suggestions on how to get started with Set Analysis and Set Expressions:
Keep it simple.
Play around with examples provided on Qlik Help*. Get familiar with the syntax and the structure of the expressions.
Take a self-paced class on our Learning portal.
We offer a few classes on set expressions and set analysis:
Review our video resources.
There are so many videos available on Set Analysis. Some of the videos are a little bit older, but they are still relevant. Here are a couple I recommend:
Search the Qlik Community.
There is so much content that has been created in the form of articles, Help documentation, Community posts and documents, YouTube videos, etc. One search will search all the available platforms so you do not have to scour the internet.
Ask your peers for help.
Use our Qlik Community forums (Qlik Sense App Development and QlikView App Dev) to get help from your peers. I love promoting our Community’s development resources. The developers out on Qlik Community are brilliant and eager to help.
Try out the Set Analysis Wizard for QlikView**
The Set Analysis Wizard for QlikView is not a Qlik tool but was created by an employee. It is also something we like to use in Qlik Support. Even though it says for QlikView, it still applies to Qlik Sense.
I hope these resources help you on your Set Analysis journey. If you have any suggestions or recommendations on materials that helped you learn Set Analysis, post them in the comments below.
Kind regards,
Qlik Digital Support
*The same document is also available for QlikView.
**The information in this post is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support may not be provided by Qlik Support.
