topic Rolling period change measure in KPI app in QlikView

Rolling period change measure in KPI app

jleefjcapital — Fri, 22 May 2015 18:50:47 GMT

I'm trying to create a rolling period change measure to use the most current period growth rate as a KPI. However, because it relies on the previous period data, it does not work for a single period. Is there a workaround?

Re: Rolling period change measure in KPI app

marcus_sommer — Sat, 23 May 2015 08:10:54 GMT

Have you already searched here within the forum for these topic: https://community.qlik.com/search.jspa?q=rolling+period

- Marcus

Re: Rolling period change measure in KPI app

ecolomer — Sat, 23 May 2015 10:42:21 GMT

You can see this: N-period rolling data, moving average, easy solution.

Re: Rolling period change measure in KPI app

jleefjcapital — Mon, 25 May 2015 16:13:22 GMT

Thank you. Actually, I was able to compute the rolling average, but the problem is I'm not able to use the most current computed value in a KPI application. It shows up as a null. I'm only able to display the change values in a line graph.