Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Hi,
Checkout,
https://community.qlik.com/docs/DOC-9162
-Hirish
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.