topic Re: Bar Chart in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/419574#M1168612 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="22099" alt="untitled.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/22099_untitled.JPG" /></P><P>Here i need average of previous quater before week 26.</P><P>Any idea?</P><P></P><P>Regards,</P><P>Tom</P></BODY></HTML> Wed, 19 Sep 2012 06:59:00 GMT thomas_skariah 2012-09-19T06:59:00Z Bar Chart https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/419573#M1168611 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can any one give an idea in which i have a weekly sales bar chart,what i need is to display avg of previous quarter before the first week in the bar chart.</P><P>In image i need avg of previous quarter&nbsp; before week 26.</P><P></P><P>Regards,</P><P>tom</P><P></P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 19 Sep 2012 06:27:44 GMT https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/419573#M1168611 thomas_skariah 2012-09-19T06:27:44Z Re: Bar Chart https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/419574#M1168612 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="22099" alt="untitled.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/22099_untitled.JPG" /></P><P>Here i need average of previous quater before week 26.</P><P>Any idea?</P><P></P><P>Regards,</P><P>Tom</P></BODY></HTML> Wed, 19 Sep 2012 06:59:00 GMT https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/419574#M1168612 thomas_skariah 2012-09-19T06:59:00Z Re: Bar Chart https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/419575#M1168613 <HTML><HEAD></HEAD><BODY><P>Hi hope this help. NOte that in the example I use to variables "vCurrentWeek" and "vWeekPreviousQuarter". They come from the script</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13480602585033616" jivemacro_uid="_13480602585033616"><P>LET vCurrentWeek = Week(Today());</P><P>LEt vWeekPreviousQuarter = vCurrentWeek-16;</P><P></P></PRE><P></P><P>I assume that when you talk about "Previous Quarter" you mean 16 weeks before and not the "natural quarter" : Jan-Mar, Ap-Jun,...</P><P>See the file attached</P></BODY></HTML> Wed, 19 Sep 2012 13:14:27 GMT https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/419575#M1168613 2012-09-19T13:14:27Z