Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Asiolinka
Contributor III
Contributor III

The easiest way to have distinct count in data load editor

Hi,

I am trying to have the same result for field count as for count distinct in visualization. Nothing special. Just have a few flags = 1. Count distinct on the chart works - I can not do it in editor.. 

Could you please advise how can I obtain the same results? 
I guess I should use 'group by' to avoid multiplication but maybe you have better idea..

 

Thank you in advance.

Labels (3)
2 Replies
Chanty4u
MVP
MVP

Try this 

Count({<Flag={'1'}>} DISTINCT Field)

 

Asiolinka
Contributor III
Contributor III
Author

I put it to the editor - it is marked by red - can I use {<Flag={'1'}>} in editor?