Discussion board where members can get started with QlikView.
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')
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"?
(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
Hi, Tom Grouwe.
Share your qvw.
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')
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).
This worked. Thank you Robin