Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
macaulay
Creator
Creator

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)

View solution in original post

jonathandienst
Partner
Partner

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
macaulay
Creator
Creator
Author

That's it, thank you!

macaulay
Creator
Creator
Author

Works, thanks a lot!