topic Re: About Time Related Query in QlikView

About Time Related Query

sarfaraz_sheikh — Wed, 07 Jan 2015 12:36:34 GMT

Dear All,

I want to calculate the top 5 agent who has refreshed aux codes within 0-3 seconds ....means i want list of that agent who takes Emergency(Comfort) break for 0-3 seconds...I tried below expression but did not get the expected result

(Interval(Time(Sum({<Reason={'COMFORT'}>} EventDuration)),'hh:mm:ss') <=MakeTime(00,00,05),Sum( {<Reason={'COMFORT'}>} EventDuration))

Attached my QVW also here for your reference check in sheet 7.

Regards

Sarfaraz

Re: About Time Related Query

Wed, 07 Jan 2015 12:56:24 GMT

Hi Sarfaraz,

Does the attached work for you?

Iqbal

Re: About Time Related Query

rubenmarin — Wed, 07 Jan 2015 12:58:44 GMT

Hi Sarfaraz, I dont' understand the requirements, you can add an expression like:

Interval(Time(Sum({<Reason={'COMFORT'}>} EventDuration)),'hh:mm:ss')

There you can check that all the agents have an interval time over 5 secs. so all of them returns FALSE in the 'if' comparison and therefore you get the empty table

Re: About Time Related Query

sarfaraz_sheikh — Wed, 07 Jan 2015 13:30:06 GMT

Dear Iqbal,

Thanks a lot ...the solution is simple inspite i made it complicated ....Anyway thanks a lot it is working now fine.

Regards

Sarfaraz

Re: About Time Related Query

sarfaraz_sheikh — Wed, 07 Jan 2015 13:31:38 GMT

Dear Ruben

See the Iqbal post above ....Everything will get clear to you ...Thanks for your reply !!

Sarfaraz