Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Re: Rolling 12 months sum

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

Highlighted
Not applicable

Re: Rolling 12 months sum

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

Highlighted
Not applicable

Re: Rolling 12 months sum

Hi Fredrik,

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

Highlighted
Contributor
Contributor

Re: Rolling 12 months sum

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.

Highlighted
Contributor III
Contributor III

Re: Rolling 12 months sum

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?

Highlighted
Creator III
Creator III

Re: Rolling 12 months sum

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