Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ext_bay
Employee
Employee

Rolling 12 months based on user date selection

Hi all,

I am trying to create a linechart. Based on the date that the user chooses, I need to display the current rolling 12 months and previous rolling 12 months. This also means I need a dynamic x-axis.

Right now I only have

Rangeavg(Above(sum(Sales), 0, 12))

Which should be the current rolling 12 months for the sum of sales.

Any ideas?

12 Replies
ext_bay
Employee
Employee
Author

PFA, there just isn't any sales data in there though

OmarBenSalem

can't help if there is no data

ext_bay
Employee
Employee
Author

Ok I'm not able to put that in. Thanks anyways!