Skip to main content

App Development

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

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mtabernad
Partner - Creator
Partner - Creator

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 (3)
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

mtabernad
Partner - Creator
Partner - Creator
Author

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