topic Re: Store Field Name into variable and use this variable in expression in QlikView

Store Field Name into variable and use this variable in expression

vikasmahajan — Fri, 20 Nov 2015 10:13:55 GMT

Hi ,

Does anybody try this scenario how to store field name into variable , and use this variable like field in expression ?

e.g Suppose I have filed xyz , then I want to store this into vFld1 and in set analysis I want to use the vFld1 ,

vFld1 should same line xyz.

Vikas

swuehl — Fri, 20 Nov 2015 10:15:52 GMT

SET vFld1 = xyz;

(or in variable overview, create the variable).

Then, in your chart expression

=Sum( [$(vFld1)] )

vikasmahajan — Fri, 20 Nov 2015 10:30:48 GMT

Thanks