topic Re: Dynamic Variable Name in Chart in QlikView

Dynamic Variable Name in Chart

Saravanan_Desingh — Tue, 01 Dec 2015 22:32:44 GMT

I have a situation like, I have to create a dynamic variable name and use in Objects, based on a button click.

I have a value coming from a variable. Let us assume 'var1' and has values of 'A', 'B' & 'C'.

Based on a button press, I am setting this value.

In an Object let us assume 'Chart', I would like to use it as a variable "A rest" or "B rest" or "C rest".

I already have these variables defined and I am trying to calculate its count.

Count([A rest])

I have tried below and its not working

Count([$(var1) rest])

Count([$(=var1) rest])

Any advise please... I hope I am clear with my situation.

Re: Dynamic Variable Name in Chart

maxgro — Tue, 01 Dec 2015 22:51:32 GMT

see attachment

Re: Dynamic Variable Name in Chart

Saravanan_Desingh — Tue, 01 Dec 2015 23:40:46 GMT

Thank you maxgro. For some reason, my calculation is done only if I reload the script. Do you think, I have to change any options in Button or Chart Object?

Re: Dynamic Variable Name in Chart

Saravanan_Desingh — Tue, 01 Dec 2015 23:48:07 GMT

Please ignore it. I was wrong in setting the values. Thanks again