topic Re: How do you use a variable in a variable? in QlikView

How do you use a variable in a variable?

Mon, 13 Oct 2014 17:16:55 GMT

Hi all,

Is it possible to use a variable in a variable in QlikView?

E.g. I have variable A and I need to use Variable A inside a Variable B!

Re: How do you use a variable in a variable?

Anonymous — Mon, 13 Oct 2014 17:22:33 GMT

Yes, it's possible.

On Variable B expression, you can call variable A using $(VariableA).

Take a look on the attached file.

Regards,

Gabriel

Re: How do you use a variable in a variable?

jyothish8807 — Mon, 13 Oct 2014 17:33:40 GMT

Hi Michael,

Its possible:

eg:

va1 =Sum(Sales)

Var2 =if(Year>='2013',$(va1),0)

Regards

Re: How do you use a variable in a variable?

maxgro — Mon, 13 Oct 2014 17:35:25 GMT

Re: How do you use a variable in a variable?

Mon, 13 Oct 2014 17:36:10 GMT

Hi ,

You can use any variable inside other variable.. by calling the variable with $ sign e.g. $(VariableA).

One more thing if your first variable is having aggregation formula in variable a then you have to put square bracket and call the variable e.g. [$(VariableA)]

Thanks

Re: How do you use a variable in a variable?

Mon, 13 Oct 2014 17:50:58 GMT

you can use variable inside the variable

suppose set vA=10; set vB=20; and vC=$(vA)+$(vB);

then in text box $(vC) will reuslt 30

Re: How do you use a variable in a variable?

Mon, 13 Oct 2014 18:05:33 GMT

Thank you so much guys! All your answers helped me understand it!