Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
Kind regards
could you send screenshot of what are you trying to achieve or/and the app/data?