topic Re: Date Difference in QlikView

Date Difference

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please find the attachment of the QVW file . I have to shows total number of days taken to close the ID And the formula is like EndDate-StartDate I tired using NUm(EndDate)-num(StartDate) but this is not giving me any result . and also in another table i have to display the same table with different expression which is like NUm(EndDate)-num(StartDate) / count(StartDate) Can please someone help me on this???

Thanks in Advance

Re: Date Difference

sunny_talwar — Fri, 13 Sep 2019 13:05:01 GMT

Change this in the script's environmental variable

SET TimestampFormat='DD-MM-YYYY h.mm.ss';

Re: Date Difference

Brett_Bleess — Thu, 26 Sep 2019 12:28:57 GMT

John, did Sunny's post get you what you needed? If so, please be sure to use the Accept as Solution button on his post to give him credit and let others know it worked. If you are still trying to get things working, leave us an update.

Regards,
Brett