Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
qluser01
Not applicable

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
Not applicable

Re: Make table immune to filter

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

4 Replies
OmarBenSalem
Not applicable

Re: Make table immune to filter

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
Not applicable

Re: Make table immune to filter

No need to add measure, try below

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

OmarBenSalem
Not applicable

Re: Make table immune to filter

Hi Vineeth,

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

Capture.PNG

vinieme12
Not applicable

Re: Make table immune to filter

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