Conditional Count Function

msawyercke — Wed, 25 Nov 2020 16:16:04 GMT

HI,

I have used the following expression in a KPI:

Count({<[Required?] = {"YES"}>}[Required?])

In my data, there are three possible entries for the field 'Required?'. They are:

YES

DONE

So the KPI is to merely count those that are currently designated as "YES".

However, I get a count in my data that is different than what is displayed in the KPI. For example, in the Excel pivot table, I get 1,507 "YES" results, and that is the same number in the Qlik pie chart of the same data. Hopwever, the KPI returns a number of 1,754.

Does my expression look incorrect?

Thanks, for anyone who can help!

Mike

Re: Conditional Count Function

swuehl — Tue, 10 Jan 2017 22:10:02 GMT

With KPI, you mean a gauge chart?

What does the expression return in a text box object?

And what is the dimension used in the pie chart? Maybe the dimension shows some NULLs in records?

topic Conditional Count Function in QlikView

Conditional Count Function

Re: Conditional Count Function