Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
any help??
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])
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
1/24/6 is 1 (day) divided by 24 (hours) divided by 6 = 10 minutes.
Please post a qlikview document that demonstrates the problem.
PFA.
<EDIT: Attachment removed on request by author>
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..."