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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
Creator

Set analysis Help

hi, there is a table, please tell me how to use Set Analysis

Vittore8_0-1588606445759.png

achieve the result

Vittore8_1-1588606543123.png

 

Labels (1)
3 Replies
agigliotti
Partner - Champion
Partner - Champion

you don't need set analysis, simple create a table as below:

- dimension: Shop
- dimension: Town
- expression: sum(Money)

I hope it helps. 

Taoufiq_Zarra

why set analysis ?

Maye be just :

dimension :shop,town

Expression :sum(Money)

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Vittore8
Creator
Creator
Author

Vittore8_0-1588608274065.png

I need to compare 2018 money with 2017, I was thinking of doing something Aggr (), but don't know how