topic Re: count function show double result in QlikView

count function show double result

Anonymous — Mon, 22 Feb 2016 04:43:35 GMT

i have a problem with count()

my project language is Persian so maybe it's difficult to understand the problem. as you see in the picture i have four people with a "فشار خون بالا" disease but in chart count() show 8

i can't figure out what's the problem

i also load my qvw file if it helps.

i would appreciate if someone can help me.

Re: count function show double result

Chanty4u — Mon, 22 Feb 2016 08:08:05 GMT

or try with

sum(urfield)

count(agg(urfield))

Re: count function show double result

kaushiknsolanki — Mon, 22 Feb 2016 08:14:46 GMT

Hi,

This is because your Join has created duplicate records.

The above chart is a tablebox which will not show you the duplicated records.

But in chart aggregation it will count even though its duplicate.

Regards,

Kaushik Solanki

Re: count function show double result

Anonymous — Tue, 23 Feb 2016 08:13:18 GMT

hi Kaushik Solanki

i use distinct and it worked. Thank you

But Why records are duplicated, which part of my join is incorrect?