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: 
idogridish2
Creator III
Creator III

Rolling forecast based on last three months

Hi,

Trying to create a forecast based on the last three months (In the Layout, not the script, the customer asks for it to be dynamic),

the issue as I see it is that we need to use the calculated forecast values for the continued forecast,

please see the attached Excel file, you will understand better,

idogridish2_0-1707127485805.png

 

Labels (4)
5 Replies
idogridish2
Creator III
Creator III
Author

Hi,

I managed to do it for three months,

see the attached QVF file,

can we improve this? because it's kind of complicated.

idogridish2_0-1707220062089.png

 

Ido.

 

Chanty4u
MVP
MVP

Try this

.Avg({<Date = {">=$(=Date(AddMonths(Max(Date), -3)))<=$(=Max(Date))"}>} Sales)

 

idogridish2
Creator III
Creator III
Author

Hi, thanks, 

did you try it on the app I provided?

Chanty4u
MVP
MVP

I don't have access to the application sorry

idogridish2
Creator III
Creator III
Author

The app is open for everyone, there is no section access.