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: 
qluser01
Creator
Creator

Make table immune to filter

Hi all!

I have a loaded data like:

And I have a Table showing Color field.

When I make a filter - Color field in Table shows only Color for this Fruit, but I want to see all Color values in table, to make Table data immune to Fruit filter.

You can use attached file...

1 Solution

Accepted Solutions
OmarBenSalem

The only way is to add a measure (count{1}(1)) for example) to your table and then change the width of its column so It can't be visible anymore :

Capture.PNG

See the attached app

View solution in original post

4 Replies
OmarBenSalem

The only way is to add a measure (count{1}(1)) for example) to your table and then change the width of its column so It can't be visible anymore :

Capture.PNG

See the attached app

vinieme12
Champion III
Champion III

No need to add measure, try below

AGGR(only({1}  FieldName) , FieldName)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
OmarBenSalem

Hi Vineeth,

I already tried that but that does not seem to do the job:

Capture.PNG

vinieme12
Champion III
Champion III

Hi Omar,

I misread the question, I thought we were working with a listbox.

You are correct we'll need to add an expression to the table

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.