topic Historical comparison in line chart in QlikView https://community.qlik.com/t5/QlikView/Historical-comparison-in-line-chart/m-p/461496#M1159734 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Suppose I've got a table of EventIDs each with a corresponding StartDateTime. I'd like to have a line graph with the horizontal dimension as the week of the year (e.g. 12/3/2012, 12/10/2012 etc.) and one expression as the count of EventIDs during a given week with another expression as the average of the three weeks prior to the given week.</P><P></P><P>I've loaded the data 3 additional times, each time with an additional +1 week offset. This can't be the way to go. Any suggestions? Thank you! -Reid</P><P></P><P>I'm aggregating the event dates by week during a LOAD statement with</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13561173367605245" jivemacro_uid="_13561173367605245"><P>Dual(WeekStart(StartDateTime), Year(StartDateTime)*100+Week(StartDateTime)) as StartWeekYear,</P></PRE><P>and I'm giving the offset to the additional tables with</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13561175645865137" jivemacro_uid="_13561175645865137"><P>Dual(WeekStart(StartDateTime + 7), Year(StartDateTime + 7)*100+Week(StartDateTime + 7)) as StartWeekYear,</P></PRE></BODY></HTML> Fri, 21 Dec 2012 19:23:08 GMT 2012-12-21T19:23:08Z Historical comparison in line chart https://community.qlik.com/t5/QlikView/Historical-comparison-in-line-chart/m-p/461496#M1159734 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Suppose I've got a table of EventIDs each with a corresponding StartDateTime. I'd like to have a line graph with the horizontal dimension as the week of the year (e.g. 12/3/2012, 12/10/2012 etc.) and one expression as the count of EventIDs during a given week with another expression as the average of the three weeks prior to the given week.</P><P></P><P>I've loaded the data 3 additional times, each time with an additional +1 week offset. This can't be the way to go. Any suggestions? Thank you! -Reid</P><P></P><P>I'm aggregating the event dates by week during a LOAD statement with</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13561173367605245" jivemacro_uid="_13561173367605245"><P>Dual(WeekStart(StartDateTime), Year(StartDateTime)*100+Week(StartDateTime)) as StartWeekYear,</P></PRE><P>and I'm giving the offset to the additional tables with</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13561175645865137" jivemacro_uid="_13561175645865137"><P>Dual(WeekStart(StartDateTime + 7), Year(StartDateTime + 7)*100+Week(StartDateTime + 7)) as StartWeekYear,</P></PRE></BODY></HTML> Fri, 21 Dec 2012 19:23:08 GMT https://community.qlik.com/t5/QlikView/Historical-comparison-in-line-chart/m-p/461496#M1159734 2012-12-21T19:23:08Z Re: Historical comparison in line chart https://community.qlik.com/t5/QlikView/Historical-comparison-in-line-chart/m-p/461497#M1159735 <HTML><HEAD></HEAD><BODY><P>Accumulation would let me get a moving average, but I'd like to be able to use the average value within another expression.</P></BODY></HTML> Fri, 21 Dec 2012 19:28:42 GMT https://community.qlik.com/t5/QlikView/Historical-comparison-in-line-chart/m-p/461497#M1159735 2012-12-21T19:28:42Z