Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
AlexPanda5
Partner - Contributor
Partner - Contributor

Diference between actual day and previous day

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!

 

2 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

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
Partner - Contributor
Partner - Contributor
Author

Hi!

It seems like Peek is not a valid function on qliksense

¿Any other idea?

Thanks!