topic Dynamic Dimension showing previous weeks data in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Dimension-showing-previous-weeks-data/m-p/649590#M1060623 <HTML><HEAD></HEAD><BODY><P>I have a chart that shows some data by week. I want the graph to show the week selected (by default the highest week) and the previous 5 weeks. is there a calculated dimension that can do this?</P></BODY></HTML> Thu, 02 Oct 2014 13:28:46 GMT 2014-10-02T13:28:46Z Dynamic Dimension showing previous weeks data https://community.qlik.com/t5/QlikView/Dynamic-Dimension-showing-previous-weeks-data/m-p/649590#M1060623 <HTML><HEAD></HEAD><BODY><P>I have a chart that shows some data by week. I want the graph to show the week selected (by default the highest week) and the previous 5 weeks. is there a calculated dimension that can do this?</P></BODY></HTML> Thu, 02 Oct 2014 13:28:46 GMT https://community.qlik.com/t5/QlikView/Dynamic-Dimension-showing-previous-weeks-data/m-p/649590#M1060623 2014-10-02T13:28:46Z Re: Dynamic Dimension showing previous weeks data https://community.qlik.com/t5/QlikView/Dynamic-Dimension-showing-previous-weeks-data/m-p/649591#M1060624 <HTML><HEAD></HEAD><BODY><P>It's possible to use a calculated dimension, but set analysis expressions usually perform better. Perhaps one of these discussions helps:</P><P><A href="https://community.qlik.com/message/6219">Set analysis - show only last 12 weeks data</A></P><P><A href="https://community.qlik.com/message/44167">Set Analysis Last n Weeks</A></P></BODY></HTML> Thu, 02 Oct 2014 14:20:21 GMT https://community.qlik.com/t5/QlikView/Dynamic-Dimension-showing-previous-weeks-data/m-p/649591#M1060624 Gysbert_Wassenaar 2014-10-02T14:20:21Z Re: Dynamic Dimension showing previous weeks data https://community.qlik.com/t5/QlikView/Dynamic-Dimension-showing-previous-weeks-data/m-p/649592#M1060625 <HTML><HEAD></HEAD><BODY><P>The first link is very useful but if I make a selection on my "week" list box then it only shows the current selection - I want the current selections show, and the previous n weeks.....</P></BODY></HTML> Thu, 02 Oct 2014 14:28:47 GMT https://community.qlik.com/t5/QlikView/Dynamic-Dimension-showing-previous-weeks-data/m-p/649592#M1060625 2014-10-02T14:28:47Z