topic Re: Calculating stock rotation in QlikView

Calculating stock rotation

petermoyaert — Wed, 25 Nov 2020 16:16:04 GMT

For calculating stock rotation, we want to take into account the sales of the last 12 months, which are not necessarily the sales of last year. So, when calculating stock rotation in april 2016, we want to take into account sales from april 2015-march 2016.

Anyone any suggestion on how to calculate this ?

Peter

Re: Calculating stock rotation

Kushal_Chawda — Thu, 14 Apr 2016 08:55:05 GMT

Make sure that MonthYear field is calculated as MonthName(Date) as MonthYear

=Sum({<MonthYear ={">=$(=addmonths(max(MonthYear),-11))<=$(=max(MonthYear))"}>} Sales)

Re: Calculating stock rotation

Gysbert_Wassenaar — Thu, 14 Apr 2016 08:58:20 GMT

For this you need either a date field or a serial numeric month field that increases by 1 for each month.

Using a date field it would be something like sum({<Year=,Month=,MyDate={">$(=Date(MonthStart(max(MyDate),-12)))<=$(=Date(MonthStart(max(MyDate))))"}>}sales)

If you have a month serial it would be something like sum({<Year=,Month=,_MonthSerial={">$(=max(_MonthSerial)-12)<=$(max(_MonthSerial))"}>}sales)