Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
hykal1993
Contributor II
Contributor II

How to do Simple Forecast of an Accumulated Loss Amount (Charts & Value)

Hi,

Can anyone help me on how to provide simple forecast for the loss amount below? If you notice in Aug 2017, the accumulative amount is similar until the rest of the year since there is no data. I would like to replace the data with accumulation of the forecast value. I would also like the value to be reflected in a table. If the answer is in script, please provide the full script since I am still new with the language.

Also, appreciate if you can explain the logic behind the forecast as well. PFA the file for your reference. Thanks.

Qlikview.png

10 Replies
hykal1993
Contributor II
Contributor II
Author

Thank you very much! Love this community, very helpful!