topic Lookup in QlikView

Lookup

Fri, 11 Feb 2011 12:50:57 GMT

Our phone management system currently has a report with over 65 000 lines of information based on dialed numbers by date.

The easy part was counting how many times each number was dialed and then sort it from the most to the least amount.

I have also got the information from our CRM system that shows the company name and known phone number (see small example attached).

What I want to see in the pivot table is the calls per day (sorted descending) but if the number is "known" also add the company name next to it?

I was able to do this in excel, but have no idea how to do it in qlikview.

My excel formula looks like this =IF((FIND(E2,B:B))=1,(A2),(""))

Thank you very much for any input on this issue.

Regards

Andries

Lookup

matt_crowther — Fri, 11 Feb 2011 12:59:26 GMT

Andries,

If you're linking/associating your Call Mgmt data to your CRM data via the Tel No then you should be able to simply drop the Company Name into the pivot.

If not I'd look into the Match() function - the help file should be useful.

Alternatively post a sample .qvw as that may help.

All the best,

Matt - Visual Analytics Ltd

Lookup

Fri, 11 Feb 2011 13:19:20 GMT

Thank you Matt, I will have a look at your suggestion.

Here is my file just in case.

Lookup

matt_crowther — Fri, 11 Feb 2011 13:58:15 GMT

Andries,

Revised Data Model attached.

Hope that helps,

Matt - Visual Analytics Ltd

Lookup

Fri, 11 Feb 2011 14:14:19 GMT

Totally awesome, thanks