topic Date diff with another row in App Development

Date diff with another row

OrbytaQliker — Wed, 13 Sep 2023 12:45:32 GMT

Hi everyone, I have a table in which the data can be aggregated by the fields A and B, as in the following image:

You can see in this pivot table how the data is aggregated.

my request is calculate the date diff of the field date2 with the previous row (es: i m in the row 3, i should calculate the date diff of field date2 of row 3 and row2), and for the first item of each aggregated data the date diff between date2 and date1.

I'd accept both the resolution in script and in frontend.

Sorry for my English and thank you very much if you can help me!!

Re: Date diff with another row

Oleg_Troyansky — Wed, 13 Sep 2023 16:47:27 GMT

Hi!

This can be done either in the script or in the layout.

In the script, you would need to load your data sorted by all the key fields (A, B, C) and then chronologically by Date, and in the load, you'd use functions Previous() and Peek() to fetch the date from the last record and to verify that the last record belongs to the same set of keys (A, B, C). You can read about this technique in my blog.

In the layout, you'd need to use the function Above() to fetch the value from the row above.

To learn more advanced development techniques, check out the agenda of the Masters Summit for Qlik - coming soon to Orlando and to Dublin!

Re: Date diff with another row

OrbytaQliker — Thu, 14 Sep 2023 07:42:57 GMT

Thank you, your suggestion works well!!!