Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mtabernad
Partner
Partner

count(field) is duplicating rows

Dear community,

I hope someone can help me since this is driving me crazy.

I have a simple table with all the fields of the model which are 9. After some date filters, only one row show up in the table but my kpi shows '2' as value.

capture29.png

My script is:

capture30.png

 

I would appreciate some help please!

 

Thank you in advance

Labels (4)
1 Solution

Accepted Solutions
sunny_talwar

The table only displays unique combination of fields listed in it. That doesn't imply that Count() would equal = 1... When you see a count  = 2, it means that there are two rows where the listed dimensions appear twice. Count(DISTINCT...) will give you 1

View solution in original post

2 Replies
sunny_talwar

The table only displays unique combination of fields listed in it. That doesn't imply that Count() would equal = 1... When you see a count  = 2, it means that there are two rows where the listed dimensions appear twice. Count(DISTINCT...) will give you 1

View solution in original post

mtabernad
Partner
Partner
Author

Thanks for your quick reply. I get your point! I understand now!