Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Count distinct duplicating figures

Hi,

I have 2 data sets that are hooked together by Staff_Name.

distinct(Staff_Name) is counting exactly double the number of staff.

What is the reason for the double count as the data model is hooked together on the Staff_Name?

thanks

Stuart

1 Solution

Accepted Solutions
Not applicable

Re: Count distinct duplicating figures

Are they exactly the same in both data sets?

4 Replies
Not applicable

Re: Count distinct duplicating figures

The correct syntax is count(distinct Staff_Name)

Not applicable

Re: Count distinct duplicating figures

Thanks Jacob.

This still produces a double count again.

If I load in one or the other data set I only get half the figure, but when both are loaded I get the double count

Not applicable

Re: Count distinct duplicating figures

Are they exactly the same in both data sets?

Not applicable

Re: Count distinct duplicating figures

Good catch - there was a missing underscore in one side of the data !

Thanks again

Community Browser