what is set analysis? exaplain brief about set analysis and their advantages?

[Anonymous]

im new to qlikview so for me set analysis is hard can any one explain briefly

[swuehl]

You probably know that a user can make selections in fields to filter the data, resulting in different aggregation results.

In short, set analysis is like programming user selections into aggregation functions, creating a specific record set context for the aggregation.

[m_woolf]

This may help:

[cgrossman]

There is some pretty good documentation out there by Qlik to explain the syntax of Set Analysis

https://help.qlik.com/en-US/sense/September2017/Content/Videos/Videos-set-analysis-introduction.htm

I have had to use it in situations similar to a count if. Number of stores in Ohio and Michigan that carry Mountain Dew

count({<State={'OH','MI'},Product={'Mountain Dew'}> } Stores)

By default the aggregate will change on user selection. You can do things like ignore what the user selected.

count({1<State={'OH','MI'},Product={'Mountain Dew'}> } Stores)

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-ana...