topic Bar Chart with calculated dimension (Month/Week) in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart-with-calculated-dimension-Month-Week/m-p/248514#M582413 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need help for this solution. I have a following scenario:</P><P></P><P>Time Dimension with Date, Year, Month, Week, Day and another table with Date and Value </P><P></P><P>I'm trying to build a bar chart with this information, selecting a specific date (MonthSelected) the chart will show:</P><P>- the average of values for each month for last 3 months (MonthSelected - 3)</P><P>- and the average of values for each week until 12 weeks forward</P><P></P><P>(Month-3) | (...) | (Month-1) | <STRONG>(MonthSelected)</STRONG> | (Next Week) | (Next Week +1) | (...) | (Next Week + 12) </P><P></P><P>I believe it can be done with calculated dimensions.. not sure... Any help?</P><P>Thanks in advance.</P></BODY></HTML> Wed, 23 Nov 2011 00:11:17 GMT 2011-11-23T00:11:17Z Bar Chart with calculated dimension (Month/Week) https://community.qlik.com/t5/QlikView/Bar-Chart-with-calculated-dimension-Month-Week/m-p/248514#M582413 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need help for this solution. I have a following scenario:</P><P></P><P>Time Dimension with Date, Year, Month, Week, Day and another table with Date and Value </P><P></P><P>I'm trying to build a bar chart with this information, selecting a specific date (MonthSelected) the chart will show:</P><P>- the average of values for each month for last 3 months (MonthSelected - 3)</P><P>- and the average of values for each week until 12 weeks forward</P><P></P><P>(Month-3) | (...) | (Month-1) | <STRONG>(MonthSelected)</STRONG> | (Next Week) | (Next Week +1) | (...) | (Next Week + 12) </P><P></P><P>I believe it can be done with calculated dimensions.. not sure... Any help?</P><P>Thanks in advance.</P></BODY></HTML> Wed, 23 Nov 2011 00:11:17 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-with-calculated-dimension-Month-Week/m-p/248514#M582413 2011-11-23T00:11:17Z