Excluding values by appying a filter

[dirk1955]

Hi,

Normaly if you click on an item in a qlikview list, the list is filtered accordingly.

I wonder if it's possible to exclude data by clicking on an item in a list.

For example:

The data list contains :              

Data	Nr
A	1
B	2
C	2
D	2
E	1
F	2
G	2
H	1
I	3
H	1

The filterlist contains:

Filter
1
2
3

By clicking 1 in the filter list i want to exclude in the table list all the values with 1 in the Nr column.

Dirk

[jonathandienst]

Hi

The set expression {1-$} excludes the current selection. Use it something like:

          Sum({1-$} Sales)

     or

          Sum({1-$<Status = {1}>} Sales)

Regards

Jonathan

[dirk1955]

Hi,

Thanks for the explanation but since i'm quit new to qlikview i realy don't understand it.

Can you give me an example please?

In fact what i want is to exclude in the table (data list) al the values where Nr = 1 if i click on 1 in the filter list.

Thanks

Dirk

[sujeetsingh]

just paste a sample of your qvd...And then any one can exp[lain you and it will be easy to you to get good with it.