Selection in Set Analysis

[Anonymous]

Hi, QlikView community

I have a formula in set analysis:

Sum({$<Region ={‘South’, 'North', 'East'}>} Sales)

In my dataset I have South, North, East and West.

So in my set analysis I do not want have information regarding West.

But here is my problem. I want to select South and look at data regarding South.

But I can't do that if my set analysis is like that.

Do you have any idea how to do that

regards Darri

[Anonymous]

Hi, I sent a dataset and qlikview document to let everybody see what I am taking about.

The two set analysis work:

1. Sum({$<Region -={‘West’}>} Sales)

2. Sum({$<Region =e({‘West’})>} Sales)

But I am trying to find set analysis that exclude everything except South, North and East.

Because in other dataset I have there are more values then in this dataset

And I can select South or North or East in my selections.

[Anonymous]

Aaah!  I think I understand your question now, try :

     Sum({$<Region *= -{"West"}>} Sales)

[Anders_Eriksson · Accepted solution]

Then it is a union you are looking for.

The selected values in Region but only those that intersect with South, North or East.

Sum({$<Region *={‘South’, 'North', 'East'}>} Sales)