3 Replies Latest reply: Mar 2, 2011 9:15 AM by jameskniep RSS

    Is it possible to reference a variable created in Qlikview?

    jameskniep

      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?