topic Re: Need Help First Call Resolution with qlik in QlikView

Need Help First Call Resolution with qlik

Anonymous — Thu, 02 Feb 2017 15:26:53 GMT

Hi, I’m looking for a solution with qlikview. Can you help me?

I have to calculate first call resolution in a contact center and the rule is that whether the same number calls again in the same day or next 3 days then first call is marked as “recall”. The calculation is “rolling” for each call.

In excel I use this function.

In my excel database I have Column A (number calling) and Column B (date call).

Can I add with script Column C (First Call Resolution) and calculate the “recall” with similar excel function or “for cycle”?

Thank you very much!!

Re: Need Help First Call Resolution with qlik

sunny_talwar — Thu, 02 Feb 2017 15:57:45 GMT

Would you be able to share your data in an Excel file format?

Re: Need Help First Call Resolution with qlik

Anonymous — Thu, 02 Feb 2017 16:30:30 GMT

Attached you can find the sample excel file.

Thank You!

Re: Need Help First Call Resolution with qlik

MarcoWedel — Thu, 02 Feb 2017 22:04:47 GMT

Maybe something like

If(Number=Previous(Number) and [Date Call]-Previous([Date Call])<=3, 'recall', 'no recall') as [First Call Resolution]

hope this helps

regards

Marco

Re: Need Help First Call Resolution with qlik

Anonymous — Fri, 03 Feb 2017 09:57:41 GMT

Thank You!

But I have to mark the first call as generating recaller, not the second.

Can I use opposite function of "previous"? Exist?

Re: Need Help First Call Resolution with qlik

MarcoWedel — Fri, 03 Feb 2017 22:38:58 GMT

Hi,

maybe just like

If(Number=Previous(Number) and Previous([Date Call])-[Date Call]<=3, 'recall', 'no recall') as [First Call Resolution]

loading resident ordered by number and [Date Call] descending?

hope this helps

regards

Marco

Re: Need Help First Call Resolution with qlik

MarcoWedel — Wed, 22 Mar 2017 21:57:41 GMT

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco