Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Total values according to each attribute

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.

2 Replies

Re: Total values according to each attribute

Try this

Dimension

Name

Expression

Count([Financial Code])

Count(DISTINCT [Financial Code])

Not applicable

Re: Total values according to each attribute

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.