topic Re: Timestamp Issue in QlikView

Timestamp Issue

Mon, 26 Nov 2012 20:20:33 GMT

I have a list box which contains no of Days......

but its caluculated like 24.05 so it says 24 days and I am not sure how many hours mins secs that .05 means....

So I changed the number format into Timestamp its displaying 24 1:12:00....

Here is the Issue when I caluculate 24.05 in secs its not same with 24 1:12:00......How to overcome this issue......

how should I change 24.05 into exact days hrs mins and secs.......

Re: Timestamp Issue

swuehl — Mon, 26 Nov 2012 20:31:14 GMT

Could you explain in more detail what you get when you calculate 24.05 in seconds?

I think 1:12:00 is the correct representation in h:mm:ss when 0.05 is a fraction of a day, so 24 1:12:00 should be ok as time interval / duration representing 24.05 as number of days.

Re: Timestamp Issue

Mon, 26 Nov 2012 20:37:24 GMT

Can you Please explain me how .05 is 1:12:00......Thanks

Re: Timestamp Issue

swuehl — Mon, 26 Nov 2012 20:41:03 GMT

0.05 means 1/20 of a day (or 5%). A day has 60*24 minutes. 60*24 minutes / 20 = 72 minutes. 72 minutes is 1 hour and 12 minutes --> 1:12:00