topic Re: Rolling last 12 months in QlikView

Rolling last 12 months

caccio88 — Sat, 28 Nov 2015 18:09:50 GMT

Hi everyone,

I'm wondering if someone could help me.

I'm trying to display the value of the last 12 months for a calculated value (Day Payable Outstanding). At every monthyear I don't want to display the value of DPO e.g. Sep '15, but I want to display the value of DPO from Oct '14 to Sep '15.

Is that clear?

As you can se iin my qvw I can calculate the DPO in the "DPO (gg)" chart and I'm trying to calculate the DPO LTM ( last twelve months) in the "DPO LTM(gg)" chart

I tried creating a rolling period but seems that my tentative and the formulas used don't works as well.

Attach here my qvw.

sunindia‌ have u ever seen something like that?

Re: Rolling last 12 months

marcus_sommer — Sun, 29 Nov 2015 09:33:11 GMT

Please do not double-posting - it's not helpful. Your example-app is quite (too) large which suggest that real-data are including instead of dummy-data, see also: Preparing examples for Upload - Reduction and Data Scrambling.

A very good explanation for rolling periods could you find here: Calculating rolling n-period totals, averages or other aggregations.

- Marcus

Re: Rolling last 12 months

HirisH_V7 — Sun, 29 Nov 2015 10:07:43 GMT

Hi,

Checkout,

https://community.qlik.com/docs/DOC-9162

-Hirish

Re: Rolling last 12 months

caccio88 — Sun, 29 Nov 2015 18:04:48 GMT

You are right Marcus_Sommer‌, it wasn't my purpose to double-posting. I was not sure if I had posted at the first time.

I've find what I was looking for in Calculating rolling n-period totals, averages or other aggregations.

Thanks for your help.