Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
sureshqv
Esteemed Contributor III

Re: Selection and Count () amount to different results

try

count(distinct Projekt)

4 Replies
sureshqv
Esteemed Contributor III

Re: Selection and Count () amount to different results

try

count(distinct Projekt)

MVP
MVP

Re: Selection and Count () amount to different results

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

macaulay
Contributor

Re: Selection and Count () amount to different results

That's it, thank you!

macaulay
Contributor

Re: Selection and Count () amount to different results

Works, thanks a lot!