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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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?