topic Compare Current Week to Previous 3 Week average in QlikView https://community.qlik.com/t5/QlikView/Compare-Current-Week-to-Previous-3-Week-average/m-p/1819121#M1213292 <P>HI,</P><P>&nbsp;</P><P>I have the following Expression to count the number of export/send to excel actions from the Governance Dashboard:</P><P class="p1"><SPAN class="s1">sum</SPAN>({&lt;<SPAN class="s2">AuditType</SPAN>={'Export','SendToExcel'}&nbsp;&gt;}<SPAN class="s2">Audit_Count</SPAN>)<SPAN class="Apple-converted-space">&nbsp;</SPAN></P><P class="p1">&nbsp;</P><P class="p1"><SPAN class="Apple-converted-space">What I would like to do is create a chart that only populates if the current weekly total (Mon-Fri) is greater than the previous 3 week average (Mon-Fri) and show this by the Authenticated_User dimension.</SPAN></P><P class="p1">&nbsp;</P><P class="p1"><SPAN class="Apple-converted-space">Many thanks for any help or advice.</SPAN></P><P class="p1"><SPAN class="Apple-converted-space">Dai</SPAN></P><P class="p1">&nbsp;</P> Thu, 01 Jul 2021 14:11:53 GMT Senor_Dai 2021-07-01T14:11:53Z Compare Current Week to Previous 3 Week average https://community.qlik.com/t5/QlikView/Compare-Current-Week-to-Previous-3-Week-average/m-p/1819121#M1213292 <P>HI,</P><P>&nbsp;</P><P>I have the following Expression to count the number of export/send to excel actions from the Governance Dashboard:</P><P class="p1"><SPAN class="s1">sum</SPAN>({&lt;<SPAN class="s2">AuditType</SPAN>={'Export','SendToExcel'}&nbsp;&gt;}<SPAN class="s2">Audit_Count</SPAN>)<SPAN class="Apple-converted-space">&nbsp;</SPAN></P><P class="p1">&nbsp;</P><P class="p1"><SPAN class="Apple-converted-space">What I would like to do is create a chart that only populates if the current weekly total (Mon-Fri) is greater than the previous 3 week average (Mon-Fri) and show this by the Authenticated_User dimension.</SPAN></P><P class="p1">&nbsp;</P><P class="p1"><SPAN class="Apple-converted-space">Many thanks for any help or advice.</SPAN></P><P class="p1"><SPAN class="Apple-converted-space">Dai</SPAN></P><P class="p1">&nbsp;</P> Thu, 01 Jul 2021 14:11:53 GMT https://community.qlik.com/t5/QlikView/Compare-Current-Week-to-Previous-3-Week-average/m-p/1819121#M1213292 Senor_Dai 2021-07-01T14:11:53Z