Discussion Board for collaboration related to QlikView App Development.
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
See this document: Calculating rolling n-period totals, averages or other aggregations
Or this blog post: The As-Of Table
hi how can i add last 2 expressions as i have month as dimension
Open the charts properties window, go to the Expressions tab and press the Add button to add a new expression.