topic Is it possible to reference a variable created in Qlikview? in QlikView

Is it possible to reference a variable created in Qlikview?

Tue, 01 Mar 2011 18:40:01 GMT

Hello,

I have been creating a Qlikview dashboard and in the process I have created a variable that makes use of a data array that is uploaded. I now wish to reference that data for further calculations, instead of always referring back to the original data array and performing the same calculations on it again. For example:

Variable = x*[Data Array]+y^2

I want to use this variable in future calculations:

Newvariable= a*variable+b^3

Instead, I always have to do the following:

Newvariable = a*(x*[Data Array]+y^2)+b^3

Any hints on how to make the code more efficient in this manner?

Is it possible to reference a variable created in Qlikview?

pover — Tue, 01 Mar 2011 18:52:45 GMT

Try using dollar-sign expansion like the following example:

Newvariable= a*$(variable)+b^3

The variable will be copied to the Newvariable before the Newvariable is calculated.

Regards.

Is it possible to reference a variable created in Qlikview?

Wed, 02 Mar 2011 13:16:20 GMT

I tried your suggestion, but I just get a blank Object. Here is my formula:

='Loss relative to mean='&

round(avg([Daily Rtn])-$(VaR),0.01)

Where

VaR = &

round(min([Daily Rtn],round(count([Daily Rtn])*(1-ConfidenceLevel))),.01)

Is it possible to reference a variable created in Qlikview?

Wed, 02 Mar 2011 14:15:15 GMT

I figured it out. Forgot to remove the & symbol. Thanks.