Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
c_latham
Contributor III
Contributor III

Interval Issue - Not working when grouping numbers

Hi All,

I have a table with the following in formation:

DelayDuration (seconds)
Break900
Break1800
Bad Weather240
Shift Change900

 

I am using this interval function to convert Duration into hh:mm - =Interval(Interval#([Duration (seconds)], 's'), 'hh:mm')

However, when i remove Duration (seconds) column from the table chart I expect Break to show as a line with an interval of '00:45' but i just get a blank line. The other 2 'non grouped' columns work as expected.

Any help would be appreciated.

Thanks!

Labels (3)
1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

this should work:

Interval(Interval#(sum([Duration (seconds)]), 's'), 'hh:mm')

View solution in original post

2 Replies
lorenzoconforti
Specialist II
Specialist II

this should work:

Interval(Interval#(sum([Duration (seconds)]), 's'), 'hh:mm')

View solution in original post

Vegar
MVP
MVP

Your expression looks fine. 

image.png

 

Maybe there is something with your source data? Have you tried to trim() the field to get rid of white spaces in the begining and end of the field. 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes