Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@Shubham_D you need to specify the $ before the variable to work fine.
If($(vVariable1)='Column1', ABC,
if($(vVariable1)='Column2', XYZ))
@Shubham_D you need to specify the $ before the variable to work fine.
If($(vVariable1)='Column1', ABC,
if($(vVariable1)='Column2', XYZ))
Hi Ramchalla,
It worked. Thanks !!
Just a small change as it worked with Single quotes,
If('$(vVariable1)'='Column1', ABC,
if('$(vVariable1)'='Column2', XYZ))