Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Not applicable

Script calculation, Charting rolling months, average calculation

Hello,

I have a need to create a bar chart which will display the past 12 months including the current month with some calculations.

Rolling 12 months formula is available in plenty across the community, but my problem is calculating the average of a particular column from previous year. I have attached an excel which covers all the details, let me know if you need more information.

Thanks.

4 Replies
Highlighted

Is this a different question than what you have asked here: Rolling Sum/Rolling Average at Script

Highlighted
Not applicable

Yes this is the actual question, and the other question is a part of it. Please give me your suggestions on this.

Highlighted
Not applicable

Any suggestions?

Highlighted
Not applicable

Is there a way to pick only the last value of every month? Fisc_Day_Of_Mth_Nbr is the month days column for me.

Avg.JPG