Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
sanjujeeboy
New Contributor II

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
Partner
Partner

Re: set analysis

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

Sum( {<Video={'Wedding'}>}SALES)
Please ekskuse my Norglish and Swenglish typos.
sanjujeeboy
New Contributor II

Re: set analysis

hi

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

sergio0592
Valued Contributor II

Re: set analysis

Try with :

=sum({<Video>} Sales)
Partner
Partner

Re: set analysis

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?
Please ekskuse my Norglish and Swenglish typos.