topic Re: Compounded Value in QlikView

Compounded Value

Anonymous — Wed, 13 Mar 2013 17:19:12 GMT

If I have a dataset as follows per below, how can define the Value for any particlar record. In Excel it is pretty striaght forward to defince value as the PreviousCellAbove*(1+r(i)).

Can I use Above to achieve this?

Re: Compounded Value

Gysbert_Wassenaar — Wed, 13 Mar 2013 17:37:25 GMT

I don't know if you can do it with above. Somehow I doubt it. But it's pretty easy to do in the script with the peek function: if(rowno()=1,1,peek(Value))*(1+Rate)*100 as Value

Re: Compounded Value

Anonymous — Wed, 13 Mar 2013 18:10:58 GMT

Thanks Gysbert - that's good to know.

Does it work when the Value is an expression? For example something like Peek(if (SUM(Value)=0,0, SUM(Value))?

Does Value have to refer to the data field that is loaded or can it refer to the Expression?

So for example if I load the data field value and I have an expression called Total Value on the chart that is If(SUM(Value)=0,0, SUM(Value)). Do I use Peek(Total Value) or Peek(if (SUM(Value)=0,0, SUM(Value))?