Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

andyrebs
New Contributor

Sales Trend rolling

Hello,

like always, I try to be clear to explain what I am looking for, and like always I need your help.

I need an expression to set a bar chart where the dimension is 'Order Date'. The expression should be the sum of the value of the orders had in the prevous 365 days of each point of dimension. What I mean is that on the point of the dimension value 01-01-2013 I would have the sum of the value of the orders between 02-01-2012 and 01-01-2013, on the point of the dimension with value 02-01-2013 I would have the sum of the value of the orders beetween 03-01-2012 and 02-01-2013.

it could be possible?

I hope you can help me.

Best regards.

Andrea

1 Reply
andyrebs
New Contributor

Re: Sales Trend rolling

does somebody has any suggestion?

Community Browser