topic Excluding values by appying a filter in QlikView

Excluding values by appying a filter

dirk1955 — Thu, 13 Dec 2012 09:17:17 GMT

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 :

The filterlist contains:

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 — Thu, 13 Dec 2012 09:27:21 GMT

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

Sum({1-$} Sales)

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

Regards

Jonathan

dirk1955 — Thu, 13 Dec 2012 09:45:54 GMT

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 — Thu, 13 Dec 2012 10:00:57 GMT

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.