Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Open and Closure Quantities

Hello,

I have an Excel sheet which logs shipments of ice cream (OrderQuantity, OrderWeight) for each month, as well as inventory count for each ice cream at the end of each month (ClosureQuantity, ClosureWeight).

I need to create a table that will have, for each month, the sum of "OpenQuantity" and "OpenWeight" and the sum of "ClosureQuantity" and "ClosureWeight", where 'OpenQuantity' of month X is the 'ClosureQuantity' of month X-1.

How can I do that?

Enclosed is the Excel sheet

Thanks

1 Reply
Specialist III
Specialist III

try to go by orderdate

 

=Sum({$<orderdate={">=$(MonthStart(Max(orderdate)))<$(=Monthhend(Max(orderdate))"}>}OpenQuantity)

 

this will bring open Quantity for selected month if not selected any month,it will choose max(date)

 

=Sum({$<orderdate={">=$(MonthStart(addMonths(Max(orderdate),-1))<$(=Monthhend(addmonths(Max(orderdate),-1)"}>}ClosureQuantity)

 

Channa