Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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
Partner

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
Partner

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