topic Re: Single Set Analysis in QlikView

Single Set Analysis

Anonymous — Wed, 20 May 2015 15:14:43 GMT

Hi All

Below Set Analysis possible as single?

Sum({$<Qtr = {1,2}> Amt) - Sum({Qtr = {3} Amt)

Question is instead of summing (Qtr = {1,2}) and subtracting (Qtr = {3}) is that possible the above SA in single Set Analysis ?

Thanks

nagaiank — Wed, 20 May 2015 15:20:19 GMT

You may use

Sum({$<Qtr = {1,2}>} Amt) - Sum({$<Qtr = {3}>} Amt)

Anonymous — Wed, 20 May 2015 15:36:18 GMT

Hi NagaianK

I agree and I have used the same, I also agree my question is little confusing.

I am trying to figure out if possible in single Set Ana like

Sum({$<Qtr = {1,2}>} Amt)

and Qtr = 3 within above only rather than Sum({$<Qtr = {1,2}>} Amt) - Sum({$<Qtr = {3}>} Amt)

Thanks for your sugestion

Wed, 20 May 2015 15:46:16 GMT

Hi Satish,

you can use different operators within set analysis, have a look at this for more on those

but you won't be able to do what you are looking for in this scenario from a single set I'm afraid no.

Joe

Wed, 20 May 2015 15:55:29 GMT

Hi,

Try like this

Sum({$<Qtr = {1,2}-{3}>} Amt)

Thanks & Regards

Harsha Nandan

Anonymous — Wed, 20 May 2015 16:17:47 GMT

It's only sum up of 1 & 2, 3 does not subtract

I am looking like this solution

Thanks