Discussion board where members can learn more about Qlik Sense App Development and Usage.
How to get day difference based on condition?
Interval between day 3 H1 to day 18 H1 is 15
Go to Solution.
Thanks for the help,
i managed to get the result by using Previous - script function.
IF([Location] = PREVIOUS([Location]),[Date] - PREVIOUS([Date])) AS Interval
ORDER BY [Location]
DROP TABLE [Sheet2];
how do you get that?
can you elaborate ?
[Date] - [Date] = Interval
18 - 3 = 15
can you share sample app?
Sure, please refer attached.