Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

paulista
New Contributor III

interval function not working properly

 

i am having a below chart

 

There are two calculations that i am trying to achieve the same result but can you help me understand why is it not giving me the same result

screenshot.PNG

 
 
 
 
 
 
 

 

Manual case creation(gives correct result)

=Interval( [collateral-valuation-reviewCaseCompleted-CPVT-REJECTED] - Min(HDR_TIMESTAMP) ,'hh:mm:ss')

 

manual case creation 2(giving no result)

=Interval(

AVG(Aggr(If(IsNull([collateral-valuation-reviewCaseCompleted-CPVT-REJECTED]), 0,
[collateral-valuation-reviewCaseCompleted-CPVT-REJECTED] - Min(HDR_TIMESTAMP)), HDR_CORR_ID))

, 'hh:mm:ss')

3 Replies
billbois
New Contributor III

Re: interval function not working properly

Just curious, but do you get a number if you remove the Interval() function? In other words, does this return a result?

=AVG(Aggr(If(IsNull([collateral-valuation-reviewCaseCompleted-CPVT-REJECTED]), 0, [collateral-valuation-reviewCaseCompleted-CPVT-REJECTED] - Min(HDR_TIMESTAMP)), HDR_CORR_ID))

 

paulista
New Contributor III

Re: interval function not working properly

no it does not unbfortunately for the same row

Re: interval function not working properly

which value should be given when Date is null? You have given 0 but  [0 - anydate] will always give you wrong results.