Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Matteo1
Partner - Contributor II
Partner - Contributor II

NO filter for a dimension

hi everybody,

I have a dimension  (BRAND) of different cars  (for example Lamborghini, Ferrari, etc.) but I also have an active filter for a specific brand (let's say Audi), based on the dimension (COMP_BRAND).

I want to create a table in which I can list all of these brands without being affected by the active filter. I already tried to use the set analysis: 

=aggr(only({<COMP_BRAND=>}BRAND),BRAND)

However it seems having some problems with this set analysis because i can't get the correct result

 

Labels (1)
4 Replies
sunny_talwar
MVP
MVP

Do you have an expression within this table? If you do, then I suggest ignoring selection in the expression for BRAND and use BRAND as your dimension instead of the calculated dimension below.

Matteo1
Partner - Contributor II
Partner - Contributor II
Author

No, I don't have any measures for this table.  I just need the table with only that dimension. Unfortunately i cannot add any extra measures

sunny_talwar
MVP
MVP

Use alternate state in that case because I don't think you can make the dimension un-selectable without using an expression.

qliksrikanth
Contributor III
Contributor III

I think this is the best solution. Use alternate state.