topic Re: Diference between actual day and previous day in App Development

Diference between actual day and previous day

AlexPanda5 — Tue, 16 Feb 2021 18:55:42 GMT

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!

Re: Diference between actual day and previous day

fvelascog72 — Wed, 17 Feb 2021 08:25:09 GMT

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.

Re: Diference between actual day and previous day

AlexPanda5 — Wed, 17 Feb 2021 10:14:29 GMT

Hi!

It seems like Peek is not a valid function on qliksense

¿Any other idea?

Thanks!