Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)