topic difference between current date and next occurance date in QlikView

difference between current date and next occurance date

Thu, 03 Jul 2014 08:43:09 GMT

Hi All,

Please find an attachment.QlikTech Admin

I want to take difference between date and next date of occurance.

For EX: I am having ABC functional location and in that different notification nos. are there so for that one notification no's date minus

next date of that function location during the month * 24. so how to handle it in script.

Gysbert_Wassenaar — Thu, 03 Jul 2014 12:27:10 GMT

It's unclear to me which date difference should be calculated. Can you give some examples?

shane_spencer — Thu, 03 Jul 2014 12:35:26 GMT

I use Interval for this. i.e.

interval ( EndDateTime - StartDateTime, 'mm') as Duration,

Perhaps with the data you have you need to combine this with Previous of Peek function?