Percentage KPI based on true and false

[Rahul88]

Hi, 

I am trying to create a Percentage KPI  for Is_finished and IS_not_finished based on column have True and false value.

When I choose False in the filter, the Is_finished KPI should show 0% and Is_not_finished KPI should show 100%.

[Rahul88]

when I use the following expression the KPI show the correct value if I don't do any filter selection.

Count(distinct {$<IS_FINISHED={True}>} ID) / Count(distinct ID)

[Rahul88 · Accepted solution]

Go the solution. 

Count(distinct {$*<IS_FINISHED={True}>} ID) / Count(distinct ID)

*	Intersection. This binary operation returns a set consisting of the records that belong to both of the two set operands.

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnaly...