Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
JAN. 24, Q&A with Qlik: Making the Move to Qlik Cloud Reporting: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jlampard40
Contributor III
Contributor III

Per Month %

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

Labels (1)
1 Reply
vinieme12
Champion III
Champion III

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)

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.