Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tomgrouwe
Contributor III
Contributor III

Issue with interval function

Dear experts,

I'm having trouble with a issue:

I have the following chart (see image)

Qlikview DB_warehousing.PNG

In this chart I would like to show "duurtotaal + uren NB" in the same presentation (dd:hh) as "#Uren".

For "Duurtotaal + Uren NB" I have set the following expression:

INTERVAL(SUM(DuurTotaal), 'dd:hh') + INTERVAL(SUM([#Uren NB])/24, 'dd:hh')

For "#Uren":

INTERVAL(SUM(#Uren)/24, 'dd:hh')

Some values are divided by 24 because the format in the sourcedocument isn't dd:hh.

What do I need to do to get the same presentation as "#uren"?

1 Solution

Accepted Solutions
Anonymous
Not applicable

perhaps:

INTERVAL(Rangesum(SUM(DuurTotaal),SUM([#Uren NB])/24),'dd:hh')

(I think, if you use "+" then the return value is a number and then your interval format will be deleted...)

View solution in original post

5 Replies
Anonymous
Not applicable

perhaps:

INTERVAL(Rangesum(SUM(DuurTotaal),SUM([#Uren NB])/24),'dd:hh')

(I think, if you use "+" then the return value is a number and then your interval format will be deleted...)

jonas_rezende
Specialist
Specialist

Hi, Tom Grouwe.

Share your qvw.

Regards,

Jonas Melo.

marioglasmv
Partner - Contributor III
Partner - Contributor III

Without the qvw we can not be sure what it should be but try the following:


INTERVAL(SUM(DuurTotaal) + (SUM([#Uren NB]) / 24), 'dd:hh')

kuba_michalik
Partner - Specialist
Partner - Specialist

In addition to what everybody else said already - INTERVAL is a formatting function. It generally makes sense to format a number only once, as the last thing you do (so, outermost function).

tomgrouwe
Contributor III
Contributor III
Author

This worked. Thank you Robin