Expression

[hkg_qlik]

Hi,

My requirement here is:

I have to claculate the difference between dates to measure oldest ticket still in open state:

vDatetoday = today's date

Status <> 'Closed' or Status <> 'Resolved'

Field which holds the date value = [Incident Created Date]

I am using the following expression but it is getting me the incorrect output.

=Num($(vDateToday)-(MinString( {1<Status -={'Closed'} >} [Incident Created Date])),'#,##0')

Thanks,

H

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

It should work with Interval() and Min(), because dates in QlikView are numeric

=Interval(Today() - Min({< Status -= {'Closed', 'Resolved'} >} [Incident Created Date]), 'DD')

Hope that helps.

Miguel