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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSenseUser2
Contributor III
Contributor III

Dividing a timestamp by a Number

I'm trying to divide timestamp by a number and get day, hour, and minute results. I currently have 

Interval(END_DATE_TIME-WO_DATE_TIME,'hh: mm')/Sum([WO Count])  this give me a number I need it the be in DD MM HH format

 

QlikSenseUser2_1-1627302293717.png

 

 

Labels (1)
10 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If there is a END_DATE_TIME for every counted workorder, you might simplify this as 

Interval( Avg(END_DATE_TIME-WO_DATE_TIME) , 'd mm hh')

-Rob