Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a data sets with different dates.
I'd like to compare values coming from 2 different dates, for instance:
Difference from 20/5 to 27/5:
Apples: + 30000
Pears: + 3000
Do you have a solution (either in script or expression)?
Many thanks in advance,
If you have only two dates you can get the maximum date Max(date) - minimum date Min(date), that works in script chart. But if you have more than one date i suggest to use peek() function.
If you need help to write the code please let me know.
In addition for Eduardo answer, you could process the table in the script:1) Loading data ordering by Product and Date;
2) Processing balance using Peek(), something like:
Values - Peek(Values) as Values2
Additional information in Peek ‒ QlikView
Vinicius Mariano de Lima