Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
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
BILL 25
BILL 57
BILL 1
BILL 1
BOB 59
BOB 20
...
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.
Thanks in advance.
Try this
Dimension
Name
Expression
Count([Financial Code])
Count(DISTINCT [Financial Code])
You know, funny thing. I did do that originally, but it didn't work.
I later found out that someone had renamed the data and I was still using the previous name (which is why it wasn't working).
But thank you for taking the time to reply.