topic Re: No. of mails responded within 10mins in QlikView

No. of mails responded within 10mins

Anonymous — Fri, 08 May 2015 12:13:29 GMT

Hi there,

I have to date and i want to no. of mails responded within 10mins. in set analysis

I have count of Log Id and within that i need below condition.

(Email received date - Open date )<=10 mins

Thanks

Anonymous — Fri, 08 May 2015 12:22:51 GMT

any help??

Gysbert_Wassenaar — Fri, 08 May 2015 12:24:31 GMT

Something like this (if your date fields contain date values and not text values):

count( {<[Log Id]={"=interval([Email received date]-[Open date])<1/24/6"}>} [Log Id])

Anonymous — Fri, 08 May 2015 12:32:23 GMT

Hi Gysbert,

I am getting 0 when i am using below expression

=count( {<Type={'Incident'},Source={'E-Mail'},[Call Log ID]={"=interval([Email received date]-[dumpOpen date])<1/24/6"}>} [Call Log ID])

and i want know is what is meaning of <1/24/6

Thanks

Gysbert_Wassenaar — Fri, 08 May 2015 12:53:37 GMT

1/24/6 is 1 (day) divided by 24 (hours) divided by 6 = 10 minutes.

Please post a qlikview document that demonstrates the problem.

Anonymous — Fri, 08 May 2015 12:56:38 GMT

PFA.

<EDIT: Attachment removed on request by author>

pokassov — Fri, 08 May 2015 13:07:35 GMT

Hi!

=count( {<Type={'Incident'},Source={'E-Mail'},[Call Log ID]={'=interval([Email Received Date]-[DumpOpen Date])<1/24/6'}>} [Call Log ID])

You wrote wrong field name, for example "dump..." instead "Dump..."