topic Re: KPI & Selection in QlikView

KPI & Selection

Thu, 05 May 2016 10:03:15 GMT

Hello,

I have an issue with my #1. I create it with a formula:

count({<Gender={'M'}>} Gender )/ Count(Employee)

Everything is ok, but when i select in a pivot table 'F" only instead of "M" the % become crazy, it doesn't integrate my selection and get above 100%. Any advises?

Thanks

Timothee

Re: KPI & Selection

sunny_talwar — Thu, 05 May 2016 14:47:37 GMT

May be this based on what you want:

Count({<Gender={'M'}>} Gender)/Count({<Gender>}Employee)

Count({<Gender *={'M'}>} Gender)/Count(Employee)

Re: KPI & Selection

Fri, 06 May 2016 00:25:04 GMT

Thank you. It seems to work.