topic Re: Creating a line chart that is partly independent from time selection in QlikView https://community.qlik.com/t5/QlikView/Creating-a-line-chart-that-is-partly-independent-from-time/m-p/785941#M278041 <HTML><HEAD></HEAD><BODY><P>Try expression:</P><P>=sum({&lt;Week={"&gt;$(=Max(Week)-10) &lt;=$(=Max(Week))"}&gt;}Number)</P></BODY></HTML> Wed, 14 Jan 2015 07:33:44 GMT tresB 2015-01-14T07:33:44Z Creating a line chart that is partly independent from time selection https://community.qlik.com/t5/QlikView/Creating-a-line-chart-that-is-partly-independent-from-time/m-p/785940#M278040 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Im experiencing a&nbsp; problem for which i dont have a solution. Im trying to make a graph that show the past 10 weeks of data when selecting a week. So if i select week 15 the chart should show week 6-15.</P><P></P><P>A basic exmapl to work with is in the attchement.</P><P></P><P>Any help will be greatly appriciated!</P><P></P><P>gr,</P><P></P><P>Aart</P></BODY></HTML> Wed, 14 Jan 2015 07:29:19 GMT https://community.qlik.com/t5/QlikView/Creating-a-line-chart-that-is-partly-independent-from-time/m-p/785940#M278040 2015-01-14T07:29:19Z Re: Creating a line chart that is partly independent from time selection https://community.qlik.com/t5/QlikView/Creating-a-line-chart-that-is-partly-independent-from-time/m-p/785941#M278041 <HTML><HEAD></HEAD><BODY><P>Try expression:</P><P>=sum({&lt;Week={"&gt;$(=Max(Week)-10) &lt;=$(=Max(Week))"}&gt;}Number)</P></BODY></HTML> Wed, 14 Jan 2015 07:33:44 GMT https://community.qlik.com/t5/QlikView/Creating-a-line-chart-that-is-partly-independent-from-time/m-p/785941#M278041 tresB 2015-01-14T07:33:44Z Re: Creating a line chart that is partly independent from time selection https://community.qlik.com/t5/QlikView/Creating-a-line-chart-that-is-partly-independent-from-time/m-p/785942#M278042 <HTML><HEAD></HEAD><BODY><P>Works like a charm! I really should read up on set analysis i realize now <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thnks for the fast response</P></BODY></HTML> Wed, 14 Jan 2015 08:18:07 GMT https://community.qlik.com/t5/QlikView/Creating-a-line-chart-that-is-partly-independent-from-time/m-p/785942#M278042 2015-01-14T08:18:07Z