Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello folks,
I have a bar chart (or a Straight Table) with the =Date(DVPG) as Dimension and 2 expressions, that are:
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
I'm sorry!
Yes, could you please adapt the code you first created to me, on the Sample project, into my real project, attached below?
As you can see, the code you sent me is not there because I had o idea how to implement it.
The sample I sent you was easier than the real project.
Would you mind doing it on my Real project?
Thanks
Check if this works
I'm sorry...
I'm using a personal edition...
Would you mind sending me the codes and scripts?
Here is the script
Thanks, Sunny
Have a nice day!