topic Re: how to resue expression in QlikView

how to resue expression

Anonymous — Sun, 08 Mar 2015 13:34:59 GMT

Something like Sum( Sales ) / Count( distinct MonthID & '|' & CustomerID ) is hard to read when analystics calculation gets complicated.

I am thinking to save this expression somewhere with a name "avg sales", then reuse it by invoking the name "avg sales" where I need?

Does Qlikview support and how if yes. Thanks.

Re: how to resue expression

maxgro — Sun, 08 Mar 2015 13:54:34 GMT

you can use variables (ctrl+ alt + v) to store expression

and reuse in different charts

Re: how to resue expression

petter — Sun, 08 Mar 2015 15:27:09 GMT

Yes - you can put the expression in a variable and in the place of the expression in your Sheet Object you can use $-sign expansion to evaluate the contents of the variable so it calculates the expression contained in the variable.

The variable can be declared in your load script or via the user interface menu: Settings/Variables Overview/Add or the menu: Settings / Document Properties / Variables Tab / New.

Something like:

avg_sales = 'Sum( Sales ) / Count( distinct MonthID & '|' & CustomerID )'

And then use this variable like this:

$(avg_sales)

In various places in Sheet Objects that allow expressions.