Rolling 12 months sum

[montubhardwaj]

Hi All,

I have explained the isssue in the attached QV file. Please refer to this. This is about calculating rolling 12 months sum.

Thanks for your time.

[#2]

hi Sajeevan,

can you help me on below post. which is almost similar to this.

https://community.qlik.com/message/997897?et=watches.email.thread#997897

[#3]

Hi Sajeevan,

I was hoping that you could help me with to fix rolling 3 months sales in the same chart as number of complaints for each month. I think it's easier when you have a look at the attached file, where I have used your sample app and done some modification.

BR

Fredrik

[#4]

Hi Fredrik,

Please find attached after adding the rolling complaints - refer the chart at the bottom

[vishnumusani]

HI Sanjeev,

Is there anyway we can display non rolling as a bar chart and rolling as line chart in a same chart.

Thanks,

MVR.

[ankitg4688]

Hi Sajeevan

I have little different scenario but in extension to this. I have a Master Calendar with Year_Month, Year and Month columns. I have a sales table which has start date, end date and sales column. I want to have rolling 13 months chart for both start date and end date when user selects Year_Month from master calendar.

sum(sales as per start date) - sum(sales as per end date)

Note:-  Accumulation and No Accumulation both.

Could you please help?

[renuka_sasikumar]

Hi,
Can we have this done in Backend level, I mean run time calculation is hitting the performance of the Dashboard