topic Excluded from result selections filter in QlikView

Excluded from result selections filter

Wed, 10 Feb 2016 15:12:51 GMT

Hi,

I need to build a selection filter that contains values I want to exclude from result.

For Example I have this filter:

When I selected Accounting or Casino etc.,I need that excluded this Values from my result.( for example report etc.)

How can I do it?

Thanks a lot

sunny_talwar — Wed, 10 Feb 2016 16:03:36 GMT

You can do something like this in your expressions:

{<Category = e(Category)>}

sfatoux72 — Wed, 10 Feb 2016 20:29:35 GMT

To don't disturb users, you could perhaps create a island table with the field ExcludedCategory

T_ExcludedCategory :

Load Distinct Category as ExcludedCategory

Resident TableWhere CategoryFieldIs;

The user will clearly select the category that he want exclude in the field ExcludedCategory

And use in your expression Sunny solution write like that :

{<Category = e(ExcludedCategory)>}