topic Re: Rolling period table in QlikView

Rolling period table

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

Hi,

I require help with rolling data.

Table 1 is the raw data. I created table 2 to show the rolling amounts with the help of information on the forum. This table is working.

Any ideas on how I could create the third table which would show the latest rolling data by Product (basically 2 columns - Product and the latest Rolling Quantity).

Thanks

Shamit

Re: Rolling period table

sunny_talwar — Fri, 13 May 2016 02:51:35 GMT

Some of the months are missing, do you want last 12 months from max date or any available last 12 months.

For last 12 months you can try this:

Sum({<ShipDate = {"$(='>=' & Date(MonthStart(Max(ShipDate), -11)) & '<=' & Date(MonthEnd(Max(ShipDate), 0)))"}>}Quantity)

Re: Rolling period table

shamitshah — Mon, 16 May 2016 00:51:39 GMT

Hi Sunny,

Thanks for the above. That work's well for the last available 12 months as you mention above.

Any idea on the expression if we wanted the last 12 months from max date i.e from today.

Thanks

Shamit

Re: Rolling period table

sunny_talwar — Mon, 16 May 2016 09:40:50 GMT

For 12 months from today, you can simply use this:

Sum({<ShipDate = {"$(='>=' & Date(MonthStart(Today(), -11)) & '<=' & Date(MonthEnd(Today(), 0)))"}>}Quantity)

Re: Rolling period table

shamitshah — Mon, 16 May 2016 10:03:06 GMT

Thanks Sunny!