Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is use of set analysis?

hi all

what is set analysis and when it will use and what is use of set analysis please tell me any one with examples

4 Replies
martinpohl
Partner - Master
Partner - Master

Hello,

with set analysis you can manipulate the calculation of a formula

eg

sum (sales) gives you the sum of the sales, depending on all selected values

sum ({<year={2014}>}sales) gives you the sum of sales from all other depending selections but only from year 2014

sum ({<year={2014}, region ={'U.S.'}>}sales) gives you the sum of sales from all other depending selections but only from year 2014 and for the region U.S.

Regards

ashwanin
Specialist
Specialist

Hi ,

this document will help you to find answer of your queries.

awhitfield
Partner - Champion
Partner - Champion

Hi Subbu,

check the attached:

Andy

maleksafa
Specialist
Specialist

set analysis is like adding a condition to an expression, if you are familiar with SQL then you can say that the set analysis represents the 'Where' clause in SQL.

for example, you have a data model which represents country, city and amount.

if you create a chart with dimension country and expression sum(amount) you will see the total amount by country.

but what if you want to select a specific city in the country, then you need set analysis, and you expression will be sum({<City={'CityName'}>} amount)