topic Current month vs 4 month average delta in QlikView https://community.qlik.com/t5/QlikView/Current-month-vs-4-month-average-delta/m-p/952519#M953895 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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)</P><P></P><P>=num(Count({&lt;MethodDesc={'1'},UtilizationMonthName={'Month0'}&gt;} Distinct Key) /count({&lt;MethodDesc={'2','3', '4'},UtilizationMonthName={'Month0'} &gt;} distinct Key),'#,##0%')</P><P></P><P>I am not sure how to go by getting the average of this percentage though over the 4 months. Any help would be great.</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 20 Nov 2015 15:45:01 GMT 2015-11-20T15:45:01Z Current month vs 4 month average delta https://community.qlik.com/t5/QlikView/Current-month-vs-4-month-average-delta/m-p/952519#M953895 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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)</P><P></P><P>=num(Count({&lt;MethodDesc={'1'},UtilizationMonthName={'Month0'}&gt;} Distinct Key) /count({&lt;MethodDesc={'2','3', '4'},UtilizationMonthName={'Month0'} &gt;} distinct Key),'#,##0%')</P><P></P><P>I am not sure how to go by getting the average of this percentage though over the 4 months. Any help would be great.</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 20 Nov 2015 15:45:01 GMT https://community.qlik.com/t5/QlikView/Current-month-vs-4-month-average-delta/m-p/952519#M953895 2015-11-20T15:45:01Z