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: 
ITStagiair
Contributor II
Contributor II

I need help with code

Hey, i need help with my code. I want to use an if statement in the peek statement. This because I want to peek to a previous row, but i want it to have the same Pid code as eachother. My goal is: when there is a grandtotal I want the code to search for the corresponding Start to that grandtotal. after that i want to see what the time difference was between the start en grandtotal. If someone can help me and needs more info please comment. I already tried some codes myself here are the things I tried myself.

ITStagiair_0-1672239373855.png

 

Labels (6)
2 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

Can you share your app with some data? It's way easier for us to test this way.

Jordy

Climber

Work smarter, not harder
ITStagiair
Contributor II
Contributor II
Author

Hey Jordy, here is the data, I hope that it is good enough!