topic Re: Issue with interval function in QlikView

Issue with interval function

tomgrouwe — Wed, 25 Nov 2020 16:16:04 GMT

Dear experts,

I'm having trouble with a issue:

I have the following chart (see image)

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"?

Re: Issue with interval function

Anonymous — Fri, 03 Mar 2017 16:50:15 GMT

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...)

Re: Issue with interval function

jonas_rezende — Fri, 03 Mar 2017 18:11:03 GMT

Hi, Tom Grouwe.

Share your qvw.

Regards,

Jonas Melo.

Re: Issue with interval function

marioglasmv — Sat, 04 Mar 2017 06:16:29 GMT

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')

Re: Issue with interval function

kuba_michalik — Sat, 04 Mar 2017 13:22:07 GMT

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).

Re: Issue with interval function

tomgrouwe — Mon, 06 Mar 2017 09:27:13 GMT

This worked. Thank you Robin