Different dimension columns in Bar Chart on the basis of variable value

[Shubham_D]

Hi,
I want to change dimension column in BAR Chart on click of button in QlikSense.
So I am setting variable value on click of button according to that I want to use 2 different columns as Dimension,

Dimension:
If(vVariable1='Column1', ABC,
if(vVariable1='Column2', XYZ))

But its not working, any suggestion ? 

Note : I cannot use alternate dimensions here.

[ramchalla · Accepted solution]

@Shubham_D you need to specify the $ before the variable to work fine.

If($(vVariable1)='Column1', ABC,
if($(vVariable1)='Column2', XYZ))

[Shubham_D]

Hi Ramchalla,

It worked. Thanks !!
Just a small change as it worked with Single quotes,

If('$(vVariable1)'='Column1', ABC,
if('$(vVariable1)'='Column2', XYZ))