How to make a daily evolution in Qlik Sense? (J / J-1) -1?

[Anonymous]

Hello,

I need to make a daily evolution in Qlik Sense, can you help me please?

I explain you:

I have a date from 01/01/2016 until today, and I have to do the evolution per day (J / J-1) -1

I create two measures with date J and date J-1

Here is my script:

Measure J: sum ({<DAY>} number)

Measure J-1: sum ({<DAY-1>} number)

This script works and gives me a table as follows:

But the problem the measures do not take account the date in set analysis but takes account into the dimension J in the table, so they give me the same value, where as I want that if in 02/09/2018, the Measure J = 1 576 710, the Measure J-1 must be = 1 597 810 (value of 01/09/2018 which is J-1),

My question is: how can I do so that the Measure J-1 takes i account nto the date in set analysis but not the dimension J of the table?

PS: I can not do Max (Date) in set analysis because I need the evolution of all the dates but not only the Max

thank you in advance