Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wenjun2016
Contributor II
Contributor II

How to create a moving average line chart in QlikSense

Hi,

I am beginner to QlikSense.

I met this problem recently.

Raw dataset: 10 locations, 5 KPI indicators per location. (same set of 7 indicators)


I computed average for 5 KPI per location. Now there is one average per location.

Then, I did a total to display in the table Total Average for all 10 locations.

All the above computed data are not store in a new table, they are computed using measure with formula and displayed directly,

Now, my requirement is to plot a line chart of the total average over a period of time (can be 1 month, 1 year, 2 year etc...) for  "selected/filtered location & selected/filtered KPI"

e.g. yearly moving average trending:

  1. Year 2013 Sept to Year 2014 Aug -> Total Average :
  2. Year 2013 Oct to Year 2014 Sept -> Total Average :
  3. Year 2013 Nov to Year 2014 Oct -> Total Average :
  4. Year 2013 Dec to Year 2014 Nov -> Total Average :

Use these 4 Total averages to plot as 4 dots on the Line chart.

I saw QlikView can do moving arrange using Rangave()

Can it work for QlikSense, and in my case, the Total Average is based on a computed averages (must I store them in one new column first?)

4 Replies
sunny_talwar

Would you be able to provide raw data and expected output from that raw data to help you better?

wenjun2016
Contributor II
Contributor II
Author

Hi Sunny,

Thanks for your reply.

Give me sometime to mask my data and will upload together with my dashboard application.

Happy New Year!

wenjun2016
Contributor II
Contributor II
Author

Hi Sunny,

Please see my dataset attached.

The summary tab is the computed averages for checking purpose.

Please also check the application attached. I am able to achieve the line chart by location, by month, by year.

However, I also need to have a line chart that is presenting moving averages, like every one point is a total average of a selected period (e.g. 6 months: Sept 14 - Feb 15, Oct 14 - Mar 15, Nov 14 - Apr 15, Dec 14 - May 15 ...)

Feel free to contact me if you are unclear about the requirement.

Thank you.

Wenjun

DKK
Contributor III
Contributor III

Hi Wenjun,

Did you  have a solution for the above requirement ?. I am also looking for the same kind of result.

Regards

Kiran