1 Reply Latest reply: Mar 14, 2016 3:59 AM by Alessandro Saccone RSS

    Can I assign a value to a variable and use it in any expressions?

      Hi Community

       

      I have defined a aggregation function that returns a value. For example:

       

           =sum(if(SNAPSHOTID=0 AND isnull(SUBSEQUENTFLAG) 1, 0))

       

      And I want to display this value on multiple sheet objects (and return value of above statement is changing depends on the selection). What I did is copy the above statement to the various expressions of different objects. So the question is - is there a better way of doing this? Such as declare a variable and use it instead of copy and paste the the whole code every time when I reuse it?

       

      I am very new to QlikView, Thanks

      Jing