Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vijayptcs
New Contributor III

No. of mails responded within 10mins

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




6 Replies
vijayptcs
New Contributor III

Re: No. of mails responded within 10mins

any help??

Re: No. of mails responded within 10mins

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])


talk is cheap, supply exceeds demand
vijayptcs
New Contributor III

Re: No. of mails responded within 10mins

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

Re: No. of mails responded within 10mins

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

Please post a qlikview document that demonstrates the problem.


talk is cheap, supply exceeds demand
vijayptcs
New Contributor III

Re: No. of mails responded within 10mins

PFA.

<EDIT: Attachment removed on request by author>

pokassov
Valued Contributor

Re: No. of mails responded within 10mins

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

Community Browser