# QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Highlighted
New Contributor III

## Selection in Set Analysis

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

Tags (2)
1 Solution

Accepted Solutions
Partner

## Re: Selection in Set Analysis

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)

12 Replies
Valued Contributor III

## Re: Selection in Set Analysis

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

New Contributor III

## Re: Selection in Set Analysis

ok, Gowtham

But if I have dataset with millions of value and I only want three.

How can I do that.

It will take hours to exclude every value that I do not want

Valued Contributor III

## Re: Selection in Set Analysis

then create a new field in the script match that three with match() function and make it null

New Contributor III

## Re: Selection in Set Analysis

I can't do anything in the expression?

I have to it in the script?

MVP

## Re: Selection in Set Analysis

Have you tried Gowtham's expression ?

Set Analysis can be surprisingly quick and efficient.

Partner

## Re: Selection in Set Analysis

Perhaps if you explain a little more what it is you're trying to do?

Your first posting sounded like there were only four distinct values.

With that I would use;

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

Valued Contributor III

## Re: Selection in Set Analysis

you can do it in expression

....

...

from tablename where match(region,'West')=0;

Partner

## Re: Selection in Set Analysis

Hi Darri,

Can u check the Region Names are Like East,West,North,South Or not.I mean Case sensitive?

Regards,

Nagarjna

MVP

## Re: Selection in Set Analysis

Try like:

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