topic Re: Count distinct duplicating figures in QlikView

Count distinct duplicating figures

Wed, 28 May 2014 12:51:44 GMT

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

Wed, 28 May 2014 12:58:16 GMT

The correct syntax is count(distinct Staff_Name)

Wed, 28 May 2014 13:16:01 GMT

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

Wed, 28 May 2014 13:25:02 GMT

Are they exactly the same in both data sets?

Wed, 28 May 2014 13:29:04 GMT

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

Thanks again