topic Re: Recursive Measures in Charts in QlikView

Recursive Measures in Charts

Anonymous — Tue, 07 Aug 2012 14:29:27 GMT

Please can someone tell me whether it is possible to have recursive formulas (expressions) in charts? I want to calculate a measure that depends on the value that comes directly before it (also calculated in the same way). A simple analogy would be a cumulative sum, but this isn't what I am trying to do. It is effectively, an auto-regressive process i.e. 90% based on the previous value and 10% based on a new value derived from another field. I can't do any of this in the loading scripts as it will be dependent on selections.

Is this possible? Any assistance would be greatly appreciated.

Thanks.

Joao

Re: Recursive Measures in Charts

giakoum — Tue, 07 Aug 2012 14:31:20 GMT

You can refer to some other calculated expression in the same chart by using the column(X) function where X is an integer representing the expression column number.

Re: Recursive Measures in Charts

swuehl — Tue, 07 Aug 2012 14:39:20 GMT

Search the Help for 'chart inter record functions'. I think these might help you in create what you want, namely above() / before(), column(), etc.