Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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