No. of mails responded within 10mins

[Anonymous]

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]

any help??

[Gysbert_Wassenaar]

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]

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]

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]

PFA.

<EDIT: Attachment removed on request by author>

[pokassov]

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..."