Per Month %

jlampard40 — Mon, 30 May 2022 13:54:51 GMT

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

Re: Per Month %

vinieme12 — Tue, 31 May 2022 07:15:53 GMT

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)

topic Per Month % in App Development

Per Month %

Re: Per Month %