Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculation distinct

Hi

How to count the number of ranches in which there document.2 ?

Thank you

13 Replies
Not applicable
Author

HI,sasikanth_Narne

But I added + 1 branch. and now in the table should be "2"Screenshot_3.png

sasikanth
Master
Master

hi

Try this expression

= count(DISTINCT aggr(count( if(document<>'document2', branch)),branch))

removed DISTINCT inside aggr, just try it.

Pls. see attachement

Not applicable
Author

Thank you

Anonymous
Not applicable
Author

count( {<Column name={'Name'}>}Distinct Documnent2)