topic Re: Interval() in QlikView

Interval()

Wed, 16 Oct 2013 05:05:09 GMT

Hi All,

I want the correct count of Incident Nos. which have SLA_RESPONSE_TIME in hours beyond what is passed on to variable. But I am not getting exact count of Incident Nos.Logic:

Count

(distinct INCIDENT_NO)-Count(distinct if(Interval((Interval#(SLA_RESPONSE_TIME,'ddd:hh:mm:ss')),'hh')<=$(vResponsePendingHours), INCIDENT_NO))

Any help would be appreciated.

Thanks in advance!!

Regards,

Ankita.

Re: Interval()

tresB — Wed, 16 Oct 2013 05:10:40 GMT

Can you please share a sample app?

Re: Interval()

sudeepkm — Wed, 16 Oct 2013 05:37:27 GMT

You may try to flag those Incidents which has crossed the SLA Response time in the script.

For example:

1. declare a variable to hold the threshold hour for e.g. vThrshold=10;

2. load

if([SLA Response time] >= '$(vThrshold)',1,0) as SLAFlag // you can use TimeStamp([SLA Response Time],'HH:mm:ss') for hours

3. in your chart expression you can use like below

count({<SLAFlag={1}>}IncidentID)