Calculation of max date and the date before

JohannesBoehmer — Fri, 17 Jun 2022 06:55:47 GMT

Hi everyone,

I´m just learning Qlik Sense and cannot find a solution in here for my problem. I

n my data model I have a Snapshotdate where a snapshot of every budget day is included. Now I´m trying to calculate the change between the most current day and the day before. Therefore I tried to create a variable with max function.

For example today is 2022-06-17, that means the last snapshot would be 2022-06-16 and the snapshot before 2022-06-13 because of public holiday.

How can I create two variable which let me calculate the change between these two days?

My try was:

LET vSnapshotDate =max(date#(SnapShotDate,'YYY-MM-DD'),0);

LET vSnapshotDate =max(date#(SnapShotDate,'YYY-MM-DD'),1);

It returns 'Null'

Re: Calculation of max date and the date before

vinieme12 — Fri, 17 Jun 2022 07:33:42 GMT

create variables in front end, not the script

https://www.youtube.com/watch?v=ZORSYf45RNU

Name : vMaxSnapshot

Expression

=Date(max(date#(SnapShotDate,'YYY-MM-DD'))) // with the leading equal sign

Name : vPriorSnapshot

Expression

=Date(max(date#(SnapShotDate,'YYY-MM-DD'),2)) // with the leading equal sign

topic Re: Calculation of max date and the date before in App Development

Calculation of max date and the date before

Re: Calculation of max date and the date before