Hello folks,
I have a bar chart (or a Straight Table) with the =Date(DVPG) as Dimension and 2 expressions, that are:
- sum(LOPP) and,
- =avg({<DVPG ={'$(=AddYears(Date(DVPG), -3))'}>} LOPP)
But the second expression is not working, it's just showing -
My intention with the second expression is to show the LOPP of 3 years ago (day-by-day).
Check the following example:
| DVPG | LOPP | my question |
| 27/05/2020 | R$ 829,45 | R$ 299,28 |
| 26/05/2020 | R$ 388,41 | R$ 976,54 |
| 25/05/2020 | R$ 451,40 | R$ 910,95 |
| … | … | … |
| 27/05/2017 | R$ 299,28 | R$ 968,37 |
| 26/05/2017 | R$ 976,54 | R$ 72,26 |
| 25/05/2017 | R$ 910,95 | R$ 732,61 |
| … | … | … |
| 27/05/2014 | R$ 968,37 | |
| 26/05/2014 | R$ 72,26 | |
| 25/05/2014 | R$ 732,61 | |
I also attached a QlikView file with some sample data.
I'm using a personal edition of QlikView so I won't be able to open any file from you!
Why I'm getting those 0, and sometimes depending on my trials I'm getting -
What am I doing wrong?
How can I show the result of LOPP of 3 years ago (day-by-day)?
Thanks
