Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
you can use variables (ctrl+ alt + v) to store expression
and reuse in different charts
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.