Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 3 buttons and this will change the value of the variable(vTest) when selected.
I am trying to create the bar chart with 2 dimensions. One of the dimension is the calculated value based on the button selection.
I am using the below expression but I am getting blank value in the second dimension. Does it need any change for the expression to work?
if(vTest=1, A,
if(vTest=2,B,
if(vTest=3,C
)))
Thanks in advance!
Hi Varun,
What happens when you put your variable in a text box $(vTest) and click on the button. Does it change to two? I think your problem lies in there.
Jordy
Climber
Hi Jordy,
It is working if I try to display text instead of the value.
i.e. if(vTest=1, 'A') - This is working and displaying A. When I try to display value for A it is not.
Get a text box, and put in the textbox '$(vTest)'. What does it say?
Jordy
Climber
It is giving me values 1, and 3 respectively based on the button selection.
Cheers,
Varun
Why isn't it giving number 2? If that is working, you can use your formula for the bar chart as a dimension.
Jordy
Climber
Sorry I missed it. It is giving me 1,2 and 3. It is not working when I try to display values from the field A.
Can you show the formula in the bar chart?