Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
shruthibk
Creator
Creator

Moving Month Average

Hi all,

i Need to find moving month average for latest 3 months,but my problem is i am using pivot table with 3 dimensions including monthyear i need to add average and deviation at the end ,please help me to achieve this

please find the sample requirement snapshot

Regards,

Shruthi

3 Replies
Gysbert_Wassenaar

See this document: Calculating rolling n-period totals, averages or other aggregations

Or this blog post: The As-Of Table


talk is cheap, supply exceeds demand
shruthibk
Creator
Creator
Author

hi how can i add last 2 expressions as i have month as dimension

Gysbert_Wassenaar

Open the charts properties window, go to the Expressions tab and press the Add button to add a new expression.


talk is cheap, supply exceeds demand