Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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