Static Alternate dimension in Qlik Sense Bar Chart

[polisetti]

Hi All,

I've created a bar chart and want to keep second alternate dimension static as highlighted in the screenshot below. Only first dimension should give option to select other dimension whereas Channel should be fixed/static (No drop-down/selection icon next to Channel)

Can we achieve this using extensions?

 Thanks,

Jaswanth

[OmarBenSalem]

Let's suppose u have 3 dimensions:

Country , Year and Channel

U want Channel to be static and variate between Country/Year.

here's how I would proceed:

Create an inline table:

Load * Inline [

Dimension,DimensionID

Country, 1

Year,2

];

Now, in ur sheet, add this Dimension field as a filter above ur chart;

as dim 1 : if(DimensionID=2,Year,Country)

as dim2 : Channel

Now, dpends on ur selections on the new field "Dimension" u'll show one of ur 2 actual dimensions (Year and Country)

Hope that was clear