topic Re: Set Analysis in QlikView

Set Analysis

rido1421 — Tue, 01 Mar 2016 18:26:56 GMT

Hi There

I need to sum a variable and use set analysis to specify the parameters to sum of that variable...

Is it possible to use Set analysis like below??? or something like it... when doing it the way I have I just get the full sum of the variable it is disregarding the set analysis which I have specified.

vGrossProfit= Sum(Sales)-Sum([Cost of Sales])

vShop1GrossProfit=Sum({<Division={'Shop1'}>}vGrossProfit)

Sum({<Desk={'Desk1'}>}vShop1GrossProfit)

Thank You

Re: Set Analysis

sunny_talwar — Tue, 01 Mar 2016 18:30:00 GMT

Unfortunately, the 2nd and 3rd expressions are not going to work like this

Re: Set Analysis

rido1421 — Tue, 01 Mar 2016 18:32:09 GMT

Would I have to do the set analysis for each scenario 1st and then create the variables?

Re: Set Analysis

marcus_sommer — Wed, 02 Mar 2016 12:05:53 GMT

I don't understand how your approach could simplify (main reason for using variables) anything. Would it not easier to use something like this:

Sum({<Division={'Shop1'}, Desk={'Desk1'}>} Sales)-Sum({<Division={'Shop1'}, Desk={'Desk1'}>} [Cost of Sales])

var:

Sum({<Division={'Shop1'}, Desk={'Desk1'}>} $1)

and then

$(var(Sales)) - $(var([Cost of Sales]))

- Marcus