topic Variable used in Expression in QlikView

Variable used in Expression

Anonymous — Sat, 01 Nov 2014 07:22:07 GMT

Dear Expert,

I am storing a value in a variable say, VOut.

Now If I am plotting this variable w.r.t to Dimension say Region. It is giving me same value throughout the report which is not right(Red MIS Report).

If I use expression instead of a variable it gives me right values(Green MIS Report).

Can I achieve same result with Variable when I use them in expression??

Pls suggest.

Regards,

Balraj

Re: Variable used in Expression

its_anandrjs — Sat, 01 Nov 2014 07:28:32 GMT

Hi,

In your variable definition remove ('=') sign in front of the variable definition and to edit variable click Ctrl + Alt + V and then write only sum([O/S]) for variable.

And then in chart use =$(VOut)

Regards

Anand

Re: Variable used in Expression

Anonymous — Sat, 01 Nov 2014 07:53:32 GMT

Thanks Anand

Re: Variable used in Expression

its_anandrjs — Sat, 01 Nov 2014 07:55:56 GMT

Thanks Please close the thread with appropriate answer for references.

Regards

Anand