Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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