Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

52 weeks average in Chart

Hi

Data is like,

WeekAmount
2016-01600
2016-02

400

2016-03

100

We have data for the past 3 years loaded, and the user can select any particular weeks. I have a line chart with Week as dimension and avg(Amount) as expression and all is fine. Now i need to show 52 week average in the line chart, along with the selected weeks. 52 Week average can be calculated as avg of past 52 weeks data. How can i achieve this?

Thanks

KRS

0 Replies