Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Asiolinka
Contributor II
Contributor II

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 II
Contributor II
Author

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