count function show double result

[Anonymous]

Hi

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.

[Chanty4u]

or try with

sum(urfield)

or

count(agg(urfield))

[kaushiknsolanki · Accepted solution]

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

[Anonymous]

hi Kaushik Solanki

i use distinct and it worked. Thank you

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