I recommend very strongly to split per floor() and frac() the timestamp into dates and times to connect them by using master-calendar and master-time-table in which beside hours, minutes and seconds also other date/time-cluster could be made. With functions like makedate() and maketime() could be each wanted combination displayed.
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
In my answer above is a link which provides various explanations and examples how to create and use such master-structures which then could be used as templates for many of your applications. Therefore you will need to take the efforts to explore them carefully to gain a better understanding how dates and times work and because dates and times topics are related to nearly each reporting-approach it's basic skills which a developer at least up to middle level will need.
