topic Re: how to use variable values as field name?? in QlikView

how to use variable values as field name??

Wed, 25 Nov 2020 16:16:04 GMT

hi there,

i want to use variable values as a filed name. is it possible??

if yes please share your ideas.

thank you

krishnacbe — Wed, 03 Aug 2016 16:16:21 GMT

Yes we can use the values as field name.

But explain what is your requirement to give more details.

Anonymous — Wed, 03 Aug 2016 16:20:30 GMT

Define the variable in the name field or write the variable expression in the name field.

Clever_Anjos — Wed, 03 Aug 2016 16:21:43 GMT

LET myvar='afield';

LOAD

field1,

$(myvar) as [$(myvar)]

from yourqvd(qvd);

Wed, 03 Aug 2016 17:42:42 GMT

ok, i have variables and If i want use to use it for calculation can i use it like this

=XIRR(($(vValue2))($(vValue)))

vVlaue and vValue2 are the variable holding date and amount.