https://community.qlik.com/t5/QlikView/last-6-weeks-same-day-avg/m-p/1737453#M452729 <P>It would likely be most helpful if you can attach QVW on this one, as I suspect folks will need to see data model, as I believe this is going to require some Set Analysis.&nbsp; The best I can offer to point you in the right direction are the following:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822</A></P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Bar_Chart.htm#anchor-14" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Bar_Chart.htm#anchor-14</A></P><P>Hopefully this may put you on the right track, but my post should kick things back up, so someone else may have some other ideas too.</P><P>Regards,<BR />Brett</P> Thu, 20 Aug 2020 15:07:24 GMT Brett_Bleess 2020-08-20T15:07:24Z https://community.qlik.com/t5/QlikView/last-6-weeks-same-day-avg/m-p/1734175#M452487 <P><SPAN>I Am try to show trend in combo chart. trend line is last 6 weeks avg. for example today Friday I want to show last 6 Fridays avg, for Thursday last 6 Thursdays like that. last 6 weeks same day avg.<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="avg.PNG" style="width: 913px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/38709i1BB8CE5A8110D948/image-size/large?v=v2&amp;px=999" role="button" title="avg.PNG" alt="avg.PNG" /></span></SPAN></P> Fri, 07 Aug 2020 16:22:16 GMT https://community.qlik.com/t5/QlikView/last-6-weeks-same-day-avg/m-p/1734175#M452487 Abhi999 2020-08-07T16:22:16Z https://community.qlik.com/t5/QlikView/last-6-weeks-same-day-avg/m-p/1737453#M452729 <P>It would likely be most helpful if you can attach QVW on this one, as I suspect folks will need to see data model, as I believe this is going to require some Set Analysis.&nbsp; The best I can offer to point you in the right direction are the following:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822</A></P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Bar_Chart.htm#anchor-14" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Bar_Chart.htm#anchor-14</A></P><P>Hopefully this may put you on the right track, but my post should kick things back up, so someone else may have some other ideas too.</P><P>Regards,<BR />Brett</P> Thu, 20 Aug 2020 15:07:24 GMT https://community.qlik.com/t5/QlikView/last-6-weeks-same-day-avg/m-p/1737453#M452729 Brett_Bleess 2020-08-20T15:07:24Z