Skip to main content

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 
Search instead for 
Did you mean: 
Rahul88
Contributor II
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
Rahul88
Contributor II
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...

View solution in original post

2 Replies
Rahul88
Contributor II
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)

Rahul88
Contributor II
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...