topic Re: counts and distinct counts in QlikView

counts and distinct counts

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a group of analysts and want to see how many times they have mentored on a list of cases this year. I want to build a table that shows their name, the number of cases they provided mentoring and lastly the number of times they mentored on each case. Something like this:

Analyst	Cases	Touches

Bob Brown	26	57

The field names are:

NOTE_NAME and CASE_ID

thanks for any help provided!

Re: counts and distinct counts

vishsaggi — Thu, 13 Apr 2017 14:59:29 GMT

What are the expression you are using here? Did not Count(Case_ID) and Count(DISTINCT Case_ID) worked? Can you provide some sample data and expected output if possible. ?

Re: counts and distinct counts

vinieme12 — Thu, 13 Apr 2017 15:02:52 GMT

dimesion

Analyst Name

Expressions

Cases: Count(Distinct NOTE_NAME)

Touches: Count(CaseID)

Re: counts and distinct counts

Thu, 13 Apr 2017 15:06:17 GMT

I tried these two expressions and ended with the same values:

Re: counts and distinct counts

vinieme12 — Thu, 13 Apr 2017 15:08:21 GMT

It'll be easier to assist if you post some sample data

Preparing examples for Upload - Reduction and Data Scrambling

Re: counts and distinct counts

vinieme12 — Thu, 13 Apr 2017 15:09:22 GMT

or maybe they actually mentored each case only once