Solved: Count Distinct Exclude Total Row - Page 2 - Qlik Community

Report Inappropriate Content · ‎2015-09-29

I have a chart with a total row. When I execute the =count(distinct(field name)) the total includes the row with the totals. Is there a way to eliminate the total row in the count? Thanks.

Anonymous · ‎2015-09-30

Yes, suppress when null is checked

Report Inappropriate Content · ‎2015-09-30

When I created a sample app to share the count function worked as desired.

avinashelite · ‎2015-10-01

Cool , if you got the answer ..please mark the correct answer and close this thread so that will be helpful for others

Report Inappropriate Content · ‎2015-10-01

Unfortunately the problem still exists in my original app.

PrashantSangle · ‎2015-10-01

Hi,

Because of it you are getting 1 extra count.

Either you can subtract 1 manually from your expression or handle null value dimension in your expression

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂