Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
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)
I figured it out. Forgot to remove the & symbol. Thanks.