Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Perfect
Thanks Fabio