If statement in bar chart dimension

[varunreddy]

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!

[JordyWegman]

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

[varunreddy]

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.

[JordyWegman]

Get a text box, and put in the textbox '$(vTest)'. What does it say?

Jordy

Climber

[varunreddy]

It is giving me values 1, and 3 respectively based on the button selection.

Cheers,

Varun

[JordyWegman]

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

[varunreddy]

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.

[JordyWegman]

Can you show the formula in the bar chart?