Visualizing Cumulative Sum with Year-Month Filters - Qlik Sense

DavideProtasi — Wed, 11 Jan 2023 08:13:06 GMT

Hello Everyone,

I'm struggling trying to visualize warehouse stock levels with Year-Month filters.

The one below is the data table of the stock in/out movements for two items (assuming no stock in the warehouse before 17/11/2022)

No problems visualizing stock levels in a bar chart with

RangeSum(Above(Sum(Stock In/Out), 0,RowNo()))

but only if I don't apply filters on the bars dimension (year-month)

How can I visualize stock levels of just some months without losing the information about stock movements of the other months?

I'd like to filter, for example, from dec 2022 to feb 2023, and obtain stock levels for item 1 (data below)

Right now this is what I get (november's data not used in the cumulative sum)

Let me know if you need any additional information about and thank you for your help!

topic Visualizing Cumulative Sum with Year-Month Filters - Qlik Sense in App Development