YTD and next 3 month data

[deepakkrish]

Hi All,

Good morning..

  I have a date field which has year 2018,2019,2020,2021 data and my requirement is I have to create a line chart to show data by month wise (jan 2019 to now)  . 

And the second one is forecasting , need to show the trend for next 3 months from today date .

Please let me know how to do this ?

Thanks in advance

Deepak.

[deepakkrish]

Can anyone help me to complete this requirement . Please let me know if you required any details from my side.

[Brett_Bleess]

Have a look at the following Design Blog post, may be something you can use on the historical:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

The forecast is something you will have to search around a  bit more, as I do not having anything for that, but I suspect there are some other posts lurking on this topic that may provide some ideas.  Did a search on the entire QlikView Forum for Forecast and got all kinds of hits, here is one with an example:

https://community.qlik.com/t5/QlikView-Documents/How-to-do-Forecasting-In-Qlikview-with-Example/ta-p...

Regards,
Brett