Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jobo
Contributor
Contributor

Transactional Stocks - Weekly Stock Value

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

Labels (3)
1 Reply
robert_mika
Master III
Master III

could you send screenshot of what are you trying to achieve or/and the app/data?