topic Annuals in QlikView

Annuals

dseelam — Tue, 05 Aug 2014 20:59:23 GMT

Hello All,

I need a annual calculation, the following was done in excel is it possible in straight or pivot table in qlik ?

If so in the annual column below each row is achieved by using this formula FOR C5 ROW = ((B5-B4)/(A5-A4))*365

	A	B	C
1	Date	Reading	Annual
2	05/04/12	1,403,817
3	06/13/12	388,888	0
4	07/11/12	1,458,250	0
5	08/21/12	1,487,134	257,809
6	09/23/12	1,505,500	200,370
7	10/15/12	1,525,153	332,586
8	11/16/12	1,553,282	320,117
9	12/19/12	1,577,608	269,649
10	01/17/13	1,597,829	254,955

sending the quw and excel

Re: Annuals

fsimoes81 — Tue, 05 Aug 2014 21:33:57 GMT

To refer another columns, you need this columns have value, in this case, yours expression cannot be calculated, then you can't values for another columns, then nothing happens.

I moved the dimensions to expression, see attached example.

Re: Annuals

dseelam — Tue, 05 Aug 2014 21:43:56 GMT

Perfect

Thanks Fabio