Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Rocky6
Creator
Creator

How to create hours minutes and seconds in measure

Hi Everyone,

Happy new year to all 

I have a small doubt i am trying to create a measure to shows avg time of calls per day. 

i am getting values as given below. 

9386:24.11. We know only we have 24 hours per day so how to calculate this measure. 

Your suggestion and answers are welcome and thanks in advance .

 

Regards

 

Labels (7)
1 Reply
steeefan
Luminary
Luminary

Please provide more context, such as the data you are using, the code of your expression etc. Might it just be a problem with the number formatting of the expression?