Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
richard_chilvers
Valued Contributor

Showing weeks up to the selected week number


I have a table of orders, including product and date ordered.

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.

I would like to add a column which shows all orders up to 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.

Ideas are welcome.

Richard

2 Replies
nishant_jadhav
New Contributor III

Re: Showing weeks up to the selected week number

Use Intervalmatch() function

richard_chilvers
Valued Contributor

Re: Showing weeks up to the selected week number


Hi

I have used Intervalmatch 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.