# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save \$200. Learn More
Highlighted
New Contributor III

## Issue with interval function

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

Tags (2)
1 Solution

Accepted Solutions
Highlighted
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...)

5 Replies
Highlighted
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...)

Highlighted
Valued Contributor

Hi, Tom Grouwe.

Regards,

Jonas Melo.

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

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

Highlighted
New Contributor III

## Re: Issue with interval function

This worked. Thank you Robin