Diference between actual day and previous day

[AlexPanda5]

Hi guys!

I want to generate a column that gives me the difference between the CARDEX-PALACE amount of the actual day and the one of the previous day.Could anyone help me?

I attach an image of the table and the script. The time fields are DIA_EXISTENCIAS and FECHA.

Thank you!

[fvelascog72]

Hi,

That´s an idea.  You could order by date and by the principal dimensions and then use peek function to compare the date with the previous day.

Saludos.

[AlexPanda5]

Hi!

It seems like Peek is not a valid function on qliksense

¿Any other idea?

Thanks!