Total values according to each attribute

Wed, 25 Nov 2020 16:16:04 GMT

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

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.

Re: Total values according to each attribute

sunny_talwar — Thu, 13 Jul 2017 15:05:08 GMT

Try this

Dimension

Name

Expression

Count([Financial Code])

Count(DISTINCT [Financial Code])

Re: Total values according to each attribute

Fri, 14 Jul 2017 08:10:41 GMT

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.

topic Total values according to each attribute in QlikView

Total values according to each attribute

Re: Total values according to each attribute

Re: Total values according to each attribute