Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

Exclude from chart where value is in selection

TL;DR When I select in a filter list "Green" I want my chart to show every row where the color is NOT Green.  Right now my set analysis looks like this, but it's not blocking the actions of the FilterList.


if(

    substringcount(GetFieldSelections(my_color,'|'),my_color) = 0

    ,my_color

    ,Null()

)


Hello Everyone,

So the gist of my problem is that I have a chart that has a field called BillTo in it  I also have a ListBox/FilterList where the user can select the BillTo.

What I want to happen is that when the user selects a certain BillTo, the chart shows BillTos that DO NOT match the selection.  The problem is that I have to tell the chart to the filtering taking place on a certain parameter but to also show the set analysis.

Any help is greatly appreciated.

1 Solution

Accepted Solutions
JustinDallas
Specialist III
Specialist III
Author

I think this solution will work just fine.

QlikSenseExcluded.png

View solution in original post

6 Replies
CarlosAMonroy
Creator III
Creator III

Hi Justin,

To do the inverse of the current selection, you can use the following set analysis:

Example:

Sum({1-$}Sales)

Hope that helps,

Carlos M

JustinDallas
Specialist III
Specialist III
Author

But what if I don't want an aggregate function?

CarlosAMonroy
Creator III
Creator III

What are the expressions in the chart?

JustinDallas
Specialist III
Specialist III
Author

There aren't any real expressions.  In the Table.  As of now, they are raw fields except for my previous attempt to exclude where instead of having the field name, I have this

if(   substringcount(GetFieldSelections(my_color,'|'),my_color) = 0 

,my_color 

,Null()

CarlosAMonroy
Creator III
Creator III

Why don't you try:

only({1-$}my_color)

JustinDallas
Specialist III
Specialist III
Author

I think this solution will work just fine.

QlikSenseExcluded.png