topic Re: Adding up values between specific dates. in QlikView

Adding up values between specific dates.

RafaelPerez — Mon, 13 May 2019 21:16:48 GMT

My main table is composed mainly of and ItemID, a Store ID, a InitialStock from Monday of that week, Sales since Monday of that week, OtherMovements and Date.

The only data that is from the date of the row is Movements, and that's what I want to add up.

I'm trying to add all the movements from Monday of that week to the selected date. For example: If I select Thursday, it should add up all the info from Monday, Tuesday, Wednesday, and Thursday, and add it up to the InitialStock and Sales to get the Stock.
I cannot provide the data set because of working policies.

Every bit of help would be appreciated.

Re: Adding up values between specific dates.

dplr-rn — Mon, 13 May 2019 18:35:35 GMT

Do you mean monday of that week?
Use setanalysis and weekstart function.
something like below (using Max(OrderDate) because if no date is selected it will show latest week)

Sum( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=WeekStart(Max(OrderDate)))"}>} LineSalesAmount)

Re: Adding up values between specific dates.

RafaelPerez — Tue, 14 May 2019 17:54:38 GMT

It worked pretty well, and used it as the base for other expressions, Thanks!

Re: Adding up values between specific dates.

dplr-rn — Tue, 14 May 2019 17:55:18 GMT

happy to help