Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

YTD and next 3 month data

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.

 

Labels (3)
2 Replies
Highlighted
Creator
Creator

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

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.