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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compare fix dimension and selected dimension

Hi I have a stacked - trelli bar chart. dimension1 is for trelli, dimension2 for the different bars and dimension 3 for the stacking and coloring.

Dimension2 (lets say state) needs to contain only 2 values which are - a fixed state (let's take Texas) and all the selected states labelled 'Others'. If there's no selection on states then only Texas state will be shown while if there is a selection, Texas will be compared to all selected states combined.

I have made this chart but I am struggling with set analysis on dimensions that is, the part where Texas gets compared with selection is not working. Is it possible? Here's the calculated dimension I have and I know why it's wrong but please help me improve it.

= if( [state]='Texas', 'Texas',

if( index( GetFieldSelections([state]), [state]) > 0, 'Others' ))

I hope I made sense. Please help me achieve this. I just started Qlikview last week.

Thanks.

0 Replies