Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
macaulay
Contributor

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
Highlighted
Chanty4u
Esteemed Contributor III

Re: Selection and Count () amount to different results

try

count(distinct Projekt)

View solution in original post

4 Replies
Highlighted
Chanty4u
Esteemed Contributor III

Re: Selection and Count () amount to different results

try

count(distinct Projekt)

View solution in original post

Highlighted
MVP
MVP

Re: Selection and Count () amount to different results

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
Highlighted
macaulay
Contributor

Re: Selection and Count () amount to different results

That's it, thank you!

Highlighted
macaulay
Contributor

Re: Selection and Count () amount to different results

Works, thanks a lot!