Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
andyrebs
Contributor III
Contributor III

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
Contributor III
Contributor III
Author

does somebody has any suggestion?