topic Re: Set Analysis Question (Excluding Dimensions) in QlikView

Set Analysis Question (Excluding Dimensions)

Mon, 24 Mar 2014 06:13:59 GMT

Hi All!

I have a question on how to make excluding of dimensions easier. I have this expression:

=sum ({<Year={$(=year($(vMaxDate)))}>}Revenue)

This gets the revenue for only the Year of the MaxDate. Let's say the maxdate is = 3/24/2014 so..

=sum ({<Year={2014}>}Revenue)

Take the Revenue for 2014. Now, Since I want to see it as a whole and not affected by every dimensions available.

Let's say I chose a month dimension. I don't want it to be affected by the month dimension so I created a set analysis like this..

=sum ({<Year={2014}, Month=>}Revenue)

And then I don't want it to be affected by other dimensions. Do I keep including it to the set analysis or is there an easier way to do this?

Thanks,

Donna

Re: Set Analysis Question (Excluding Dimensions)

AbhijitBansode — Mon, 24 Mar 2014 06:26:37 GMT

create variable :

vSetModifier = Month=,Quarter=   // add whatever dimensions to include separated by comma

Experssion would be:

sum({<Year={2014},$(vSetModifier)>}Revenue)

Re: Set Analysis Question (Excluding Dimensions)

Mon, 24 Mar 2014 06:28:47 GMT

Hi,

Please find like this,

Sum({$<Year={},Month=,Customer=,Region=>}Sales)

Regards,

Raja.

Re: Set Analysis Question (Excluding Dimensions)

Mon, 24 Mar 2014 06:37:46 GMT

Hi,

Sum({1-$<Year=,Month=,Customer=,Region=>}Sales)

REgards,

Raja.

Re: Set Analysis Question (Excluding Dimensions)

Mon, 24 Mar 2014 06:56:07 GMT

Can you send me an example qvw with those expression? I got an error producing this one.

Re: Set Analysis Question (Excluding Dimensions)

Mon, 24 Mar 2014 07:01:15 GMT

Hi! I think this set analysis takes the previous Sales. Correct me if I am wrong. Thank you though for you answer

Re: Set Analysis Question (Excluding Dimensions)

semperaugustus — Mon, 24 Mar 2014 07:42:43 GMT

sum({1<Year={2014}>} Revenue)

1 in set analysis exclude all dimension

Re: Set Analysis Question (Excluding Dimensions)

Mon, 24 Mar 2014 08:06:29 GMT

Got it!

Re: Set Analysis Question (Excluding Dimensions)

Fri, 02 May 2014 12:47:46 GMT

Just a clarification, '1' ignores selections, 'TOTAL' ignores DIMENSIONS

sum({<Year={2014}>} TOTAL Revenue)

Re: Set Analysis Question (Excluding Dimensions)

pgriffiths — Thu, 06 Sep 2018 15:32:35 GMT

Thanks Patrick Tabin,

Just what I was looking for.

'TOTAL' ignores DIMENSIONS