I am new to Qlikview so please forgive what probably is going to be an easy question.
I have two columns in an excel sheet. One column has names, and the other has scores achieved. An example would be:
Name Financial code
I'm trying to find the expression that would allow me to total the code numbers for each person and display them in straight table. I also need to total the distinct code for each person. So in a straight table it would look like:
Name Total Distinct
BILL 4 3
BOB 2 2
So in the above example need, Bill has 4 codes against his name, 3 of which are distinct (meaning he has more than one code the same against his name).
Does anyone have any idea how I can do this?
I should add that I am using an online interface and don't yet have the Qlikview app installed, so could you please not attach a .qvw file.