Count is twice of total rows of data

[#1]

I'm pretty new to qlikview and I was using count() function to count the number of total rows that matched specific criteria. When I tried linking two tables and used the function to count one of the linked fields, the total number is twice of how many total data points are in that field. Is this supposed to happen/can I change it. Also, the total count in the statistics box is displayed as n/a.

Any help is appreciated, thanks!

[Nicole-Smith]

That means there is something wrong with your link.  Can you post your load script and a sample app?

[mjm · Accepted solution]

Hello Stephen,

it may be an issue with the data-model, but I believe DISTINCT can help. This can be used like in the example below:

count(DISTINCT field_name)

Does this show any better results?

Please mark as helpful if this helps.

Thanks

[Nicole-Smith]

Doing the count distinct may make the calculation right, but it isn't going to fix the problem of the bad link in the script...

[#5]

For proprietary reasons I can't post the script, but for my purposes, DISTINCT fixed the problem. Thank you for all your help!