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

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

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.