# 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

Tags (3)
1 Solution

Accepted Solutions
Partner

## Re: Set Analysis Question (Excluding Dimensions)

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

1 in set analysis exclude all dimension

9 Replies
Valued Contributor

## Re: Set Analysis Question (Excluding Dimensions)

create variable :

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

```sum({<Year={2014},\$(vSetModifier)>}Revenue)
```
Not applicable

## Re: Set Analysis Question (Excluding Dimensions)

Hi,

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

## Re: Set Analysis Question (Excluding Dimensions)

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

1 in set analysis exclude all dimension

Not applicable

Got it!

Not applicable

## Re: Set Analysis Question (Excluding Dimensions)

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

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

Contributor

## Re: Set Analysis Question (Excluding Dimensions)

Thanks Patrick Tabin,

Just what I was looking for.

 'TOTAL' ignores DIMENSIONS