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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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