Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatg6759
Creator III
Creator III

Rounding timestamp to hour

Hello Everyone,

I have a field called readtimestamp% . we have some books where people read we get timestamp. we need to find how many people read per  hour on a day.

It has something like

02/02/2014  01:07:00  

02/02/2014  00:00:14

How can i round them to

02/02/2014  01:00:00

02/02/2014  00:00:00

Thanks,

Venkata

37 Replies
venkatg6759
Creator III
Creator III
Author

Can you suggest me how can i achieve that since i don't have timestamp in the consumption QVD .

Any method that would be possible ?

rogerioqv
Creator II
Creator II

Venka,

You can send me a sample of the two QVD's? I believe it would be easier to mount something.

johnca
Specialist
Specialist

The only thing you can sort on is the day itself. If you do not have the hour of day in your data model, you cannot do what you want. When I look at your data in the table viewer, it shows only the date, and does not contain the hour (and minutes, seconds) of each reader. Yuo need these to do what you want.

Venkata2.bmp

venkatg6759
Creator III
Creator III
Author

Thanks for your help.check the sample qvds iam sending them in excel .You can try to link them

Thanks,

Venkata

eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi, Venkata

You need to get your consumption with date and time. In your data, you have only date.

Eduardo

rogerioqv
Creator II
Creator II

Venka,

Unfortunately, upon receiving the worksheets, I found that you need to create the timestamp in the table consumption ... field without this information we will not get the amount by date / time.

venkatg6759
Creator III
Creator III
Author

Thank you so much for everyone for all the efforts.

I understand that without timestamp in the table we cannot join to calender and get it by renaming it.

Thanks,

Venkata

pratap6699
Creator
Creator

Screenshot.jpg

  • Avg. Time Spent by Employee on Floor
  • Calculate Team Utilization (use formula -Total time/Number of days per activity ) solve any body??