topic show previous weeks data based on selection in QlikView https://community.qlik.com/t5/QlikView/show-previous-weeks-data-based-on-selection/m-p/649531#M1059473 <HTML><HEAD></HEAD><BODY><P> </P><P><SPAN style="font-size: 8pt;">I have the below expressions that I want to plot on a graph (it returns an amount of time). I want the graph to plot the Maximum available "Week" (which is a field in my table) and then the previous n weeks (will probably be 13 but I should be able to change it in the expression)</SPAN></P><P> </P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Left</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TaskType</SPAN><SPAN style="font-size: 8pt;">,4)='PACK',</SPAN><SPAN style="color: #800000; font-size: 8pt;">WorkTimeAverage</SPAN><SPAN style="font-size: 8pt;">))/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Left</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TaskType</SPAN><SPAN style="font-size: 8pt;">,4)='PACK',</SPAN><SPAN style="color: #800000; font-size: 8pt;">LineQty</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P></BODY></HTML> Thu, 02 Oct 2014 14:19:24 GMT 2014-10-02T14:19:24Z show previous weeks data based on selection https://community.qlik.com/t5/QlikView/show-previous-weeks-data-based-on-selection/m-p/649531#M1059473 <HTML><HEAD></HEAD><BODY><P> </P><P><SPAN style="font-size: 8pt;">I have the below expressions that I want to plot on a graph (it returns an amount of time). I want the graph to plot the Maximum available "Week" (which is a field in my table) and then the previous n weeks (will probably be 13 but I should be able to change it in the expression)</SPAN></P><P> </P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Left</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TaskType</SPAN><SPAN style="font-size: 8pt;">,4)='PACK',</SPAN><SPAN style="color: #800000; font-size: 8pt;">WorkTimeAverage</SPAN><SPAN style="font-size: 8pt;">))/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Left</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TaskType</SPAN><SPAN style="font-size: 8pt;">,4)='PACK',</SPAN><SPAN style="color: #800000; font-size: 8pt;">LineQty</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P></BODY></HTML> Thu, 02 Oct 2014 14:19:24 GMT https://community.qlik.com/t5/QlikView/show-previous-weeks-data-based-on-selection/m-p/649531#M1059473 2014-10-02T14:19:24Z