Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

caccio88
Not applicable

Rolling last 12 months

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?

1 Solution

Accepted Solutions
marcus_sommer
Not applicable

Re: Rolling last 12 months

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

3 Replies
marcus_sommer
Not applicable

Re: Rolling last 12 months

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

hirishv7
Not applicable

Re: Rolling last 12 months

Hi,

Checkout,

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

-Hirish

“Aspire to Inspire before we Expire!”
caccio88
Not applicable

Re: Rolling last 12 months

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.