topic Help with Addmonths() set analysis in QlikView

Help with Addmonths() set analysis

sangeess21 — Sat, 16 Nov 2024 03:11:20 GMT

All,

I'm trying to add the Forecast Quantity based on monthly lead time. For example, if an Item has 217 days as order lead time, monthly lead time is 7 and I add the Forecast quantities of the first seven months. My expression works fine when an item is selected, but it does not work and sums up all 12 months when no selections are made. Any help is greatly appreciated!

Below is my expression:

sum({<Forecast_Date = {">=$(=Date(MonthStart(Today(1)))) <$(=Date(addmonths(MonthStart(today(1)),[Monthly Lead Time])))"}>}[Forecast Quantity])

Thanks!

Re: Help with Addmonths() set analysis

sunny_talwar — Tue, 25 Jun 2019 18:21:15 GMT

May be you need to do a Max here?

Sum({<Forecast_Date = {">=$(=Date(MonthStart(Today(1)))) <$(=Date(MonthStart(Today(1), Max([Monthly Lead Time]))))"}>} [Forecast Quantity])

Re: Help with Addmonths() set analysis

sangeess21 — Tue, 25 Jun 2019 21:11:42 GMT

It's not working. It still summing up the quantities of the 12 months.

Re: Help with Addmonths() set analysis

sunny_talwar — Wed, 26 Jun 2019 11:07:12 GMT

Would you be able to share a sample where we can see the issue?