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