topic Re: what is set analysis? exaplain brief about set analysis and their advantages? in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

swuehl — Mon, 30 Jul 2018 17:38:58 GMT

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 — Mon, 30 Jul 2018 18:24:24 GMT

This may help:

cgrossman — Mon, 30 Jul 2018 18:55:57 GMT

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

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)