Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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
Partner
Partner

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

Sum( {<Video={'Wedding'}>}SALES)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
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
Partner
Partner

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?
Plees ekskuse my Swenglish and or Norweglish spelling misstakes