topic Re: time rounding to a new date, but data does not shift with it... in QlikView

time rounding to a new date, but data does not shift with it...

Sun, 21 Aug 2016 20:44:51 GMT

Hi,

I have the following problem. I have a dataset which as a record every hour. unfortunately the recorded time shifts from the format 23:00:00 and 24:00:00 to 23:59:59 during the month of April and this every year. But 23:59:59 is already 00:00:00 of the next day. So once a year during this particular month I get 25 records for a day and all my records are shiftet 1 hour from there on...

I have now rounded my time with the following: timestamp(round(Dato, 1/24), 'DD-MMM-YYYY hh:mm') as Time_Data and it actually worked fine, BUT somehow the datainfromation is not shiftet to the next day.

I have attached a screenshot, which illustrates my problem. I have a master calendar which I use to look at my data and when I choose the 10th of April (in this case) I get 25 records, instead that it shows only the ones for the 10th...

Does anyone know what to do in such a case?

Thanks a lot, Barbara

Re: time rounding to a new date, but data does not shift with it...

Anonymous — Mon, 22 Aug 2016 06:40:31 GMT

Hi Barbara,

Rounding to hour, when your timestamp is great than 30 minutes, it will be one more hour.

Try with this:

TimeStamp(Date(Floor(Dato))+Hour(Dato),'DD-MMM-YYYY hh:mm')

Regards!

Re: time rounding to a new date, but data does not shift with it...

Siva_Sankar — Mon, 22 Aug 2016 07:10:52 GMT

Smaller or equal too calculating with times

Correct Time Arithmetic | Qlikview Cookbook

Re: time rounding to a new date, but data does not shift with it...

Anonymous — Wed, 24 Aug 2016 17:28:39 GMT

Please, check the correct answer.

thank you