Per Month %

[jlampard40]

Hi - I'm trying to calculate our KPI performance, based per month, for specific areas.  I have the following formula:

=Count([REPKPIData_EventKey])/ Count (TOTAL <REPKPIData_MonthReported> {<[REPKPIData_KPI]>} REPKPIData_EventKey)

I can use this in a chart and it will give me a nice monthly view in % terms.  However, I'd like to produce a text box, or even a Qlikview gauge, to show specific KPI performance for our Cancer Performance (field=REPKPICancerPerf) for month of 2022-04 (field=REPKPIMonth).  How can I amend the above formula to just show our KPI for Cancer Performance and just for 2022-04?  In % terms...

Many thanks in advance!  Kind regards

[vinieme12]

as below

=Count({<REPKPIMonth={'2022-04'}>}[REPKPIData_EventKey])/ Count ({<REPKPIMonth={'2022-04'}>} TOTAL <REPKPIData_MonthReported> {<[REPKPIData_KPI]>} REPKPIData_EventKey)

You cam make this dynamic to consider for max month if no selections are made or show selected month

=Count({<REPKPIMonth={"$(=Date(max(Date),'YYYY-MM'))"}>}[REPKPIData_EventKey])/ Count ({<REPKPIMonth={"$(=Date(max(Date),'YYYY-MM'))"}>} TOTAL <REPKPIData_MonthReported> {<[REPKPIData_KPI]>} REPKPIData_EventKey)