Dynamic Variable in expression.

[#1]

HI everyone,

I have three buttons 'Avg' , 'Min' and 'Max' which when pressed assigns variable 'vSet' as 'Avg','Min'&'Max' respectively

I have line chart which in the expression it says 'avg({<Dept={Clerk}>}salary)'

I want the expression to change to min,max and avg when the button is pressed,

i tried '=vSet({<Dept={Clerk}>}salary) but it didnt worked.

Any help will b appreciated.

[Anonymous]

Hi,

Try like this

'$(vSet)'({<Dept={Clerk}>}salary)

Thanks,

Vignesh

[#3]

i tried $(#vSet)({<Dept={Clerk}>}salary) and it worked.

Thnx for the suggestion.

[PrashantSangle]

Hi,

You can try alternate solution

Try like

create 3 expression and show them conditionally.

Or

Create 3 chart and hide/show them conditionally.

Regards

[#5]

Hi,

You Can create 3 expressions and enable them based on Condition.

PFA, Hope it helps you.

Thanks,

Vamsi