Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
wossenhh
Creator
Creator

Year-End Forecast analysis

Hello QV guru’s,

Can you please help me out how to write the expression for Year-end Forecast that shows the selected month + forward. For e.g. since I am using a fiscal year from April to March, when a user select Dec, the calculation amount should be from Dec 2016 till March 2017.

So the calculation for YTD Forecast will be :

Sum(History_Shipment * Price_Price) + Sum(Forecast_Adjusted Forecast * Price) for the current month forward in time.

Thanks

Wossen

Labels (1)
1 Reply
wossenhh
Creator
Creator
Author

Any help on this please?