QlikView Set Analysis

QlikView Set Analysis is a feature of the QlikView Business Intelligence (BI) platform that allows users to define and apply specific filters or conditions to a QlikView document or chart. It allows users to create dynamic sets of data that can be used to analyze and compare different subsets of data within a QlikView document.

Set Analysis is typically used to create dynamic filters that can be applied to a QlikView document or chart. For example, a user might create a set of data that represents all sales made in a particular region or during a specific time period. The user can then apply this set to a chart or report, and the chart or report will only show data for the specified region or time period.

Let’s first examine the main characteristics of set analysis before delving into the syntax of the set expression.

• It ought to be applied to aggregation operations.
• Curly brackets are used to start and terminate a set expression.
• It is utilised to create various selections.
• Every modifier begins and ends with >.
• Set analysis calls for the usage of the operator = and the identifier $.

Set Analysis can be particularly useful for analyzing data trends and patterns over time, or for comparing data from different regions or business units. It allows users to easily & quickly create dynamic sets of data that can be used to slice and dice the data in a QlikView document in a variety of ways.

The Set Analysis tool in QlikView is used to divide the data in many sheet objects into numerous sets while maintaining the values in some of them. In plainer language, it introduces the ability to prevent some sheet objects from being associated with others, although the default approach is for all sheet objects to be linked together. This makes it possible to filter the data in one sheet object and see the results in others, while the sheet object selected as a different set displays values in accordance with its own filters.