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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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