topic Re: set analysis in QlikView

set analysis

sanjujeeboy — Sat, 16 Nov 2024 03:30:48 GMT

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

how to do this using set analysis?

Re: set analysis

Vegar — Wed, 22 May 2019 06:48:32 GMT

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

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

Re: set analysis

sanjujeeboy — Wed, 22 May 2019 06:52:10 GMT

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

Re: set analysis

sergio0592 — Wed, 22 May 2019 07:09:49 GMT

Try with :

=sum({<Video>} Sales)

Re: set analysis

Vegar — Wed, 22 May 2019 07:30:59 GMT

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?