topic Re: Dynamic Variable in expression. in QlikView

Dynamic Variable in expression.

Thu, 29 Jan 2015 04:20:45 GMT

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 — Thu, 29 Jan 2015 04:46:53 GMT

Hi,

Try like this

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

Thanks,

Vignesh

Thu, 29 Jan 2015 04:56:58 GMT

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

Thnx for the suggestion.

PrashantSangle — Thu, 29 Jan 2015 05:03:04 GMT

Hi,

You can try alternate solution

Try like

create 3 expression and show them conditionally.

Create 3 chart and hide/show them conditionally.

Regards

Thu, 29 Jan 2015 05:26:07 GMT

Hi,

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

PFA, Hope it helps you.

Thanks,

Vamsi