Expression

hkg_qlik — Mon, 15 Oct 2012 13:53:16 GMT

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,

Re: Expression

Miguel_Angel_Baeyens — Mon, 15 Oct 2012 13:57:00 GMT

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