Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjujeeboy
Creator
Creator

set analysis

i have a dimension "Video". i want to calculate sales for this dimension.

 

how to do this using set analysis?

Labels (1)
4 Replies
Vegar
MVP
MVP

Assuming you want to see the sum of sales for Wedding Videos you can do this.

Sum( {<Video={'Wedding'}>}SALES)
sanjujeeboy
Creator
Creator
Author

hi

i want to see overall sales of "Video" dimension. im not selecting any particular field like wedding

sergio0592
Specialist III
Specialist III

Try with :

=sum({<Video>} Sales)
Vegar
MVP
MVP

If you are not making any selections to that field or want to pinpoint certain values outside of your current selection then you might not need to use set analysis. The plain Sum(SALES) might do it for you? If not please elaborate, maybe you can post a picture of your current data and what kind of output you are expecting?