Lookup

[#1]

Hi

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

[matt_crowther]

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

[#3]

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

Here is my file just in case.

[matt_crowther]

Andries,

Revised Data Model attached.

Hope that helps,

Matt - Visual Analytics Ltd

[#5]

Totally awesome, thanks