topic Re: Create a filter pane that excludes instead of Include in App Development

Create a filter pane that excludes instead of Include

robin_heijt — Wed, 31 Oct 2018 11:31:55 GMT

Hi,

I was wondering if through set analysis of some sorts I can create a filter pane that instead of creating a selection will create a exclusion.

I know it is possible to select excluded in the filter menu, but I want it to be more efficient that if i select something in the filter pane, the selection will immediately be excluded.

Thanks.

Re: Create a filter pane that excludes instead of Include

sunny_talwar — Wed, 31 Oct 2018 11:36:43 GMT

Look here

https://www.infinityinsight.com/blog/?p=270

Re: Create a filter pane that excludes instead of Include

rubenmarin — Wed, 31 Oct 2018 11:48:02 GMT

Hi Robin, maybe with a set analysis like:

{<FieldName={"*"}-{$(=chr(39)&GetFieldSelections(FieldName, chr(39)&','&chr(39))&chr(39))}>}

Re: Create a filter pane that excludes instead of Include

rubenmarin — Wed, 31 Oct 2018 11:51:09 GMT

{<FieldName=E(FieldName)>}

Yes, that's looks more clean, I forgot about E()

Re: Create a filter pane that excludes instead of Include

robin_heijt — Wed, 31 Oct 2018 13:42:26 GMT

Thanks both,

I get the logic now. But when I use this expression I get an error in expression. Anything I might have to add to the expression?

Re: Create a filter pane that excludes instead of Include

sunny_talwar — Wed, 31 Oct 2018 13:48:22 GMT

As long as you get the desired output using the e() function, you can ignore any errors (red wiggly lines) that syntax editor shows you.

Re: Create a filter pane that excludes instead of Include

robin_heijt — Wed, 31 Oct 2018 15:14:20 GMT

Unfortunately I am not getting the desired result.

If my field would be called "Name" and represents all the names in my field.

What would be my expression to show all the names and by clicking then exclude the people from the list?

Cheers Sunny

Re: Create a filter pane that excludes instead of Include

sunny_talwar — Wed, 31 Oct 2018 15:26:18 GMT

If(GetSelectedCount(Name) = 0, Sum(Measure), Sum({<Name = e(Name)>}Measure)

Re: Create a filter pane that excludes instead of Include

robin_heijt — Wed, 31 Oct 2018 17:19:23 GMT

Unfortunately this does not work for me. The expression editor accepts the expression, but the filter pane still shows an error.

I am also curious as to why a measure is being used to show a dimension. Would you care to explain ?

Cheers

Re: Create a filter pane that excludes instead of Include

sunny_talwar — Thu, 01 Nov 2018 10:59:33 GMT

I am not entirely sure what you are going after, would you be able to provide a sample app to show what you have and what you are trying to do?

Re: Create a filter pane that excludes instead of Include

robin_heijt — Thu, 01 Nov 2018 11:14:45 GMT

This picture is a screenshot of my filter pane with names.

Normally when I select a name it filters on this specific person.

What I would like to achieve is that when I select a name, instead of selecting this person it will exclude the person. So if I would select Laura in this list, it will exclude her from the selection and select everyone else.

Re: Create a filter pane that excludes instead of Include

sunny_talwar — Thu, 01 Nov 2018 11:26:09 GMT

But this exclusion is needed in a chart with some kind of expression, right? or are you looking for a dashboard wide solution?

Re: Create a filter pane that excludes instead of Include

robin_heijt — Thu, 01 Nov 2018 13:13:59 GMT

Hi Sunny,

No it would not be specific to a chart. Now I indeed understand the logic of your set analysis.

What I would want is to have a dashboard wide exclusion.

So if I would select Laura in the previous example, I do not want her information to be shown throughout the entire dashboard.

Re: Create a filter pane that excludes instead of Include

sunny_talwar — Thu, 01 Nov 2018 13:18:39 GMT

So, in that case you need an AND mode filter pane... check here

Generating AND, OR , NOT selection logic in Qlik Sense

Re: Create a filter pane that excludes instead of Include

sunny_talwar — Thu, 01 Nov 2018 13:19:57 GMT

Actually the above link is doing this using set analysis as well. I am not sure if there is an AND mode in Qlik Sense. But this was available in QlikView (AND-Mode) which would have made it possible for you to do it across the dashboard.

Re: Create a filter pane that excludes instead of Include

robin_heijt — Thu, 01 Nov 2018 14:03:20 GMT

Thanks Sunny, Unfortunately this does not seem to be an option in Qlik Sense.

Thank you for explaining the logic anyway. I will have to look forward to a feature like this then.

Cheers