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: 
Anonymous
Not applicable

Selection and Count () amount to different results

Dear all,

I got one problem with counting a quantity of fields.

I need to simply count the number of projects. As shown in the example, I choose 105 projects. But the result of "Count(Projekt)" leads to 369 projects, what might be the result of some double (or more) countings because of different sources, that may lead to this result.

Is there a possibility to figure out the result, that is reperesented by the selection on the upper left? In best case I want to define this result as a variable to do further work with it as displaying avarage project-value and else.

Thanks for your help in advance.

Regards

Tom Müller

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

try

count(distinct Projekt)

View solution in original post

4 Replies
Chanty4u
MVP
MVP

try

count(distinct Projekt)

jonathandienst
Partner - Champion III
Partner - Champion III

Am i missing something? Count(DISTINCT Projekt) should work for you.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

That's it, thank you!

Anonymous
Not applicable
Author

Works, thanks a lot!