Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Mad58
Contributor
Contributor

Excluding Selected results from filter results

I have a filter Letters:  B, C, D
I have another column Animals: Duck, Cat, Bird

I want a way so that when I press B, Animals not associated with B to appear --> Duck and Cat.

is there a way?

is there a way to use {1-$} in this case? 

Labels (4)
2 Replies
KGalloway
Creator II
Creator II

Do you think the following would work?

1. Select the filter letters you want to exclude (group in the pictures below).

2. Choose the option for "Select alternative" to select all other filter letters.

This way, by choosing "b" in "group" and then selecting the alternatives (a and d), my final table shows all records not associated with "b" in "group"

 

KGalloway_0-1672948614222.png

KGalloway_1-1672948640603.png

KGalloway_2-1672948661860.png

KGalloway_3-1672948677346.png

 

 

 

 

Bill_Britt
Former Employee
Former Employee

Hi,

Did  KGalloway solution help? If so can you mark his comment as the solution?

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.