Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
tomgrouwe
New 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"?

Tags (2)
1 Solution

Accepted Solutions
robin_hausdoerfer
Valued Contributor III

Re: Issue with interval function

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
robin_hausdoerfer
Valued Contributor III

Re: Issue with interval function

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

jonas_rezende
Valued Contributor

Re: Issue with interval function

Hi, Tom Grouwe.

Share your qvw.

Regards,

Jonas Melo.

Partner
Partner

Re: Issue with interval function

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

Partner
Partner

Re: Issue with interval function

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
New Contributor III

Re: Issue with interval function

This worked. Thank you Robin