Merging Fields

[#1]

Hi

I have a spreadsheet that I have brought into QlikView. It is part of a larger report but it is not affected by the other elements in that report. I want to be able to merge the 3 fields User1, User2 and User 3 to give me a list of users but I also want to be able to give a count of how many times that user has occurred.

My intention is to show this information in a table of some sort such as below:

User	Pick Errors
Ryan	3
Danny	8
Brett	3
Jacob	6
Ian	4

I have attached the qvw.

[awhitfield]

Daft question, have you got an Employees table? I can't open the QVW to see!

Andy

[#3]

Hi Andy

Nope, I did wonder that, but then some of the things that you guys do in Qlikview has me baffled so I didn't question it.

Steve

[awhitfield]

Ha ha, guess that explains the error then

[awhitfield]

Hi Steve, can you post the xls from the original Merger Test.qvw?

Cheers

Andy

[#6]

Hi Andy

Spreadsheet attached.

Steve

[awhitfield · Accepted solution]

@Hi Steve,

I've come to the conclusion that the only way to do this would be as per gwassenaar suggestion using a cross table load, however you may need to rename field to stop it interfering from you other data.

[#8]

Thanks Andy

I have stopped it dropping a couple of the fields and done a distinct count on those and I am getting the numbers I am expecting.

Thank you for the help.

Steve