Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zameeruddin
Contributor
Contributor

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

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

3 Replies
swuehl
MVP
MVP

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
Master II
Master II

This may help:

cgrossman
Contributor
Contributor

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...