Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis Question (Excluding Dimensions)

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Set Analysis Question (Excluding Dimensions)

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

1 in set analysis exclude all dimension

9 Replies
cabhijit
Valued Contributor

Re: Set Analysis Question (Excluding Dimensions)

create variable :

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

Experssion would be:

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

Not applicable

Re: Set Analysis Question (Excluding Dimensions)

Hi,

Please find like this,

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

Regards,

Raja.

Not applicable

Re: Set Analysis Question (Excluding Dimensions)

Hi,

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



REgards,

Raja.

Highlighted
Not applicable

Re: Set Analysis Question (Excluding Dimensions)

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

Not applicable

Re: Set Analysis Question (Excluding Dimensions)

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

Partner
Partner

Re: Set Analysis Question (Excluding Dimensions)

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

1 in set analysis exclude all dimension

Not applicable

Re: Set Analysis Question (Excluding Dimensions)

Got it!

Not applicable

Re: Set Analysis Question (Excluding Dimensions)

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

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

pgriffiths
Contributor

Re: Set Analysis Question (Excluding Dimensions)

Thanks Patrick Tabin,

Just what I was looking for.

'TOTAL' ignores DIMENSIONS