Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current month vs 4 month average delta

Hello,

I am using the following expression in my chart to return a percentage for a specific method used. I am doing this over the course of 4 months (month1,month2,month3)

=num(Count({<MethodDesc={'1'},UtilizationMonthName={'Month0'}>} Distinct Key) /count({<MethodDesc={'2','3', '4'},UtilizationMonthName={'Month0'} >} distinct Key),'#,##0%')

I am not sure how to go by getting the average of this percentage though over the 4 months. Any help would be great.

Thank you.

0 Replies