topic Re: Showing weeks up to the selected week number in QlikView https://community.qlik.com/t5/QlikView/Showing-weeks-up-to-the-selected-week-number/m-p/783215#M277302 <HTML><HEAD></HEAD><BODY><P>Use Intervalmatch() function</P></BODY></HTML> Wed, 11 Mar 2015 12:15:12 GMT Anonymous 2015-03-11T12:15:12Z Showing weeks up to the selected week number https://community.qlik.com/t5/QlikView/Showing-weeks-up-to-the-selected-week-number/m-p/783214#M277301 <HTML><HEAD></HEAD><BODY><P><BR />I have a table of orders, including product and date ordered.</P><P></P><P>In my chart I show each product and the weekly order total. The user can select the week or weeks. So they can select week 6 and see all orders for that week.</P><P></P><P>I would like to add a column which shows all orders <SPAN style="text-decoration: underline;">up to</SPAN> the selected week (ie. for weeks 1-6). I cannot use set analysis to filter out the week selected, because the table may show orders for weeks after week 6.</P><P></P><P>Ideas are welcome.</P><P>Richard</P></BODY></HTML> Wed, 11 Mar 2015 12:13:30 GMT https://community.qlik.com/t5/QlikView/Showing-weeks-up-to-the-selected-week-number/m-p/783214#M277301 richard_chilvers 2015-03-11T12:13:30Z Re: Showing weeks up to the selected week number https://community.qlik.com/t5/QlikView/Showing-weeks-up-to-the-selected-week-number/m-p/783215#M277302 <HTML><HEAD></HEAD><BODY><P>Use Intervalmatch() function</P></BODY></HTML> Wed, 11 Mar 2015 12:15:12 GMT https://community.qlik.com/t5/QlikView/Showing-weeks-up-to-the-selected-week-number/m-p/783215#M277302 Anonymous 2015-03-11T12:15:12Z Re: Showing weeks up to the selected week number https://community.qlik.com/t5/QlikView/Showing-weeks-up-to-the-selected-week-number/m-p/783216#M277303 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P></P><P>I have used <STRONG>Intervalmatch</STRONG> in other models - but only within the script. In this case, the week number of each order is clearly defined, but I am struggling how best to build the correct expression which selects the weeks I have described.</P></BODY></HTML> Wed, 11 Mar 2015 13:39:07 GMT https://community.qlik.com/t5/QlikView/Showing-weeks-up-to-the-selected-week-number/m-p/783216#M277303 richard_chilvers 2015-03-11T13:39:07Z