topic Re: Using variables in expression of Pie Chart in QlikView

Using variables in expression of Pie Chart

Wed, 28 Jan 2015 09:38:03 GMT

HI everyone,

I have made a Pie Chart displaying avg(salary)

i have made three buttons 'Avg' , 'Min' , "Max' which set variable 'vSet' as 'Avg' 'Min' & 'Max' accordingly.

i want the expression to b written as vSet(salary) but it throws error i also tried =$(vSet(salary))

how to write it proper way.

any suggestions will b very helpful

jagan — Wed, 28 Jan 2015 09:53:07 GMT

Hi,

Try like this

Create one more variable vExpression = vSet & '(salary)'

Now in expression editor you can use

=$(vExpression)

Hope this helps you.

Regards,

Jagan.

Wed, 28 Jan 2015 12:46:34 GMT

i tried as you said but Instead of evaluating it shows me 'min(salary)' as output.

it dosen't shows the value it shows characters i.e min(salary)

sunny_talwar — Wed, 28 Jan 2015 13:29:25 GMT

Is this what you want? PFA

Update: Expression used $(vSet)(salary) or ($(vSet)(Data) in my case)

Best,

jagan — Wed, 28 Jan 2015 13:54:42 GMT

Hi,

Did you given = in variable declaration for vExpression ? You have give = like below

vExpression =vSet & '(salary)'

Then it works, I think you missed it.

Regards,

Jagan.

Wed, 28 Jan 2015 16:07:16 GMT

Thank you.