Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Have you already searched here within the forum for these topic: https://community.qlik.com/search.jspa?q=rolling+period
- Marcus
You can see this: N-period rolling data, moving average, easy solution.
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.