Compare fix dimension and selected dimension

Fri, 20 Nov 2020 18:02:30 GMT

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.

topic Compare fix dimension and selected dimension in QlikView

Compare fix dimension and selected dimension