Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

Tags (2)
4 Replies

Re: Script calculation, Charting rolling months, average calculation

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

Not applicable

Re: Script calculation, Charting rolling months, average calculation

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

Not applicable

Re: Script calculation, Charting rolling months, average calculation

Any suggestions?

Not applicable

Re: Script calculation, Charting rolling months, average calculation

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