Qlik Sense - Interval based on condition

[sth_wch004]

Dear Expert,

How to get day difference based on condition?

Interval between day 3 H1 to day 18 H1 is 15

[shraddha_g]

how do you get that?

can you elaborate ?

[sth_wch004]

Hi Shraddha,

[Date] - [Date]  = Interval

18 -  3 = 15

[shraddha_g]

can you share sample app?

[sth_wch004]

Thanks,

Sure, please refer attached.

[sth_wch004 · Accepted solution]

Thanks for the help,

i managed to get the result by using Previous - script function.

LOAD

*,

IF([Location] = PREVIOUS([Location]),[Date] - PREVIOUS([Date])) AS Interval

RESIDENT [Sheet2]

ORDER BY [Location]

;

DROP TABLE [Sheet2];