topic Re: Distinct Count in QlikView

Distinct Count

evansabres — Fri, 02 Dec 2016 17:38:24 GMT

Hello I have a field (projectNME that has 4 possible values.

I have a list of 2,681 records of which these 4 values (print, digital, motion & video) comprise all of the records.

I want to get a count of how many times print, digital, etc appear. What is the expression?

Re: Distinct Count

sunny_talwar — Fri, 02 Dec 2016 17:39:42 GMT

May be add projectNME as a dimension and Count(projectNME) as expression

Re: Distinct Count

evansabres — Fri, 02 Dec 2016 17:45:47 GMT

These seems to only count the 4 unique projectNME's. I am looking for the distinct number of times that 'print' and 'motion' appear

Re: Distinct Count

sunny_talwar — Fri, 02 Dec 2016 17:47:40 GMT

Are you sure you are doing this?

Dimension

projectNME

Expression

Count(projectNME)

Do not add DISTINCT to your expression. This will give you a chart where you will have print, digitial as your dimension and number of times they appear

Re: Distinct Count

sunny_talwar — Fri, 02 Dec 2016 17:48:38 GMT

I am not sure what you mean distinct number of times? Can you elaborate by sharing a sample with expected output?

Re: Distinct Count

evansabres — Fri, 02 Dec 2016 17:53:55 GMT

My data appears as this. Trying with the actual field names this time

jobsJobTypeID

In my script, I have an in-line table, which appears as:

jobsJobTypeID, JobType

1, Print

2, Digital

3, Motion

4, Video

I want to calculate from the data, the number of times total that '1' (Print) appears and so on.

Re: Distinct Count

sunny_talwar — Fri, 02 Dec 2016 18:00:00 GMT

May be this

Dimension

JobType

Expression

Count(jobsJobTypeID)

Output from this data should look like this

JobType	Count(jobsJobTypeID)
Print	3
Digital	3
Motion	2
Video	3

Re: Distinct Count

evansabres — Fri, 02 Dec 2016 18:02:35 GMT

Perfect, thank you!