topic 1 chart, 2 expressions, 2 dimension in QlikView https://community.qlik.com/t5/QlikView/1-chart-2-expressions-2-dimension/m-p/356445#M132304 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P>A client ask for the next things...</P><P>I have a bar/line chart with a dimension of year_week (2010-1, 2010-2, etc). </P><P>1 line expression is quite simple. </P><P>The other one has to do the following:</P><P>Show acumulated sales by year in the current/selected week. </P><P>If we are in the 11 week of the year, I need for every year a bar in week 11 with the YTD sales.</P><P></P><P>I found a workaround using 2 graphs (and making the front transparent) and with an auxiliar table for the weeks acumulation </P><P>2010-1&nbsp;&nbsp; 2010-1</P><P>2010-2&nbsp;&nbsp; 2010-1</P><P>2010-2&nbsp;&nbsp; 2010-2</P><P>...</P><P></P><P>Does anyone imagine a solution but in only 1 chart?</P><P></P><P>Regards</P><P></P><P>Federico</P></BODY></HTML> Fri, 16 Mar 2012 16:06:25 GMT 2012-03-16T16:06:25Z 1 chart, 2 expressions, 2 dimension https://community.qlik.com/t5/QlikView/1-chart-2-expressions-2-dimension/m-p/356445#M132304 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P>A client ask for the next things...</P><P>I have a bar/line chart with a dimension of year_week (2010-1, 2010-2, etc). </P><P>1 line expression is quite simple. </P><P>The other one has to do the following:</P><P>Show acumulated sales by year in the current/selected week. </P><P>If we are in the 11 week of the year, I need for every year a bar in week 11 with the YTD sales.</P><P></P><P>I found a workaround using 2 graphs (and making the front transparent) and with an auxiliar table for the weeks acumulation </P><P>2010-1&nbsp;&nbsp; 2010-1</P><P>2010-2&nbsp;&nbsp; 2010-1</P><P>2010-2&nbsp;&nbsp; 2010-2</P><P>...</P><P></P><P>Does anyone imagine a solution but in only 1 chart?</P><P></P><P>Regards</P><P></P><P>Federico</P></BODY></HTML> Fri, 16 Mar 2012 16:06:25 GMT https://community.qlik.com/t5/QlikView/1-chart-2-expressions-2-dimension/m-p/356445#M132304 2012-03-16T16:06:25Z 1 chart, 2 expressions, 2 dimension https://community.qlik.com/t5/QlikView/1-chart-2-expressions-2-dimension/m-p/356446#M132305 <HTML><HEAD></HEAD><BODY><P>Rangesum(Above(sum(sales),0,Week))</P><P></P><P></P><P>This should accumulate the number of the current week back</P><P></P><P></P><P>IE if week is 11 it would sum the sales for the past 11 weeks</P></BODY></HTML> Fri, 16 Mar 2012 16:23:18 GMT https://community.qlik.com/t5/QlikView/1-chart-2-expressions-2-dimension/m-p/356446#M132305 2012-03-16T16:23:18Z