I use a transactional fact table in Qlik Sense that maps the stock level. It includes (among other things) a posting date and a quantity. I would now like to display the calendar week (in the format year-CW, e.g. 2025-CW35) in a tabular view, along with the opening stock level for the week and the closing stock level for the week. I would like to be able to filter by calendar week and still see the correct opening and closing stock levels.
I have already tried the following set expression for the opening balance: Sum({$<[POSTING_DATE.Calendar.YearCW]=,POSTING_DATE=,[POSTING_DATE.Calendar.Date]={"<$(=min([POSTING_DATE.Calendar.WeekStart]))"}>} QUANTITY)
When I then filter by calendar week (YearCW), I also see the previous calendar weeks in the tabular view because I empty YearCW in the set expression, as I need the previous bookings for the calculation. But how can I display the opening and closing balances for each calendar week in the table without also seeing the previous calendar weeks?
