topic Re: Percentage KPI in QlikView

Percentage KPI

roebrich — Tue, 15 Aug 2017 16:37:30 GMT

Hello,

I have 2 fields on my table, assignment_group and number. I want to calculate the percentage with the formula count(number) where assignment_group is null / total number.

I want it to be a KPI placed on a text object.

Thank you!

Re: Percentage KPI

Anonymous — Tue, 15 Aug 2017 16:39:45 GMT

count(if(isnull(assignment_group),number))/count(number)

Re: Percentage KPI

ecolomer — Tue, 15 Aug 2017 16:40:46 GMT

Are you sure? Count(number)?

Count(if(IsNull(assignment_group),number))/count(TOTAL number)

Re: Percentage KPI

sunny_talwar — Tue, 15 Aug 2017 16:45:07 GMT

Or create a flag in the script

LOAD number,

assignment_group,

If(Len(Trim(assignment_group)) = 0, 1, 0) as NullFlag

FROM ....;

and then this expression

Count({<NullFlag = {1}>} number)/Count(number)

Re: Percentage KPI

Anonymous — Tue, 15 Aug 2017 16:58:02 GMT

count({< $-<assignment_group={"*"} >} number)) /count(number)

--> should be faster...