Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
GeosoftRim
Contributor III
Contributor III

time slot

Hello ,
I want to define hourly time slots (midnight to 1 a.m., 1 to 2 a.m., ... 3 p.m. to 4 p.m. and so on) to follow the activity throughout the day and identify the period of the day when it there is no more charge.
Can you help me ?
thanks in advance

4 Replies
Or
MVP
MVP

Dayname(YourField) + Hour(YourField)/24

If you want them as a string rather than a timestamp, replace the + with an & and remove the /24.

GeosoftRim
Contributor III
Contributor III
Author

thank you for your answer 

here is what it gives in abscissa
The distribution of the activity is good but just the abscissa display which is erroneous

GeosoftRim_1-1634551624892.png

 

Or
MVP
MVP

I don't know what abscissa is.

You need to format this expression to match the format you want, e.g.

Timestamp(Dayname(YourField) + (Hour(YourField)/24),'DD-MM-YYYY hh)

 

GeosoftRim
Contributor III
Contributor III
Author

the abscissa is the Horizontal coordinate