# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor II

## Percentage KPI based on true and false

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%.

1 Solution

Accepted Solutions
Contributor II
Author

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...

2 Replies
Contributor II
Author

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)

Contributor II
Author

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...

Tags
Community Browser