Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vijayptcs
New Contributor III

Open date is month

Hi All,


How i will get [DumpOpen Date] is  month


Percentage of Total number of call logs where Type is Incident, Source is Emails and (Email received date - Open date )<=10 mins by Total number of call logs where Type is Incident ,Source is Emails

  and Open date is month


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



Thanks


2 Replies
MVP
MVP

Re: Open date is month

You can't do this type of row by row comparison using set analysis; set analysis is performed once for the whole data set, and not on each row.

You can use count(if()) like this:

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

/ count({<Type={'Incident'}, Source={'E-Mail'}>} [Call Log ID])

If that performs poorly, calculate [Email Received Date] - [DumpOpen Date]  in a derived field in the load script:

LOAD ....

     [Email Received Date] - [DumpOpen Date]  As OpenInterval,

     ...

Then use the field like this

=count({<Type={'Incident'}, Source={'E-Mail'}, OpenInterval= {"<$(=1/24/6)"}>} [Call Log ID])

/

count({<Type={'Incident'}, Source={'E-Mail'}>} [Call Log ID])

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vijayptcs
New Contributor III

Re: Open date is month

Hi Jonathan,

Thanks for your reply but i need Open date is month in set analysis.

Thanks

Community Browser