In this chapter, we will cover several of the QlikView tabs in the example CFO dashboard for ideas to use in forecasting and examining trends:
How to create a trend line or extend a forecast line in Charts using the Sales Analysis tab
The nuts and bolts of the Trending tab
The nuts and bolts of the What If? tab
Being able to predict likely future business scenarios by examining forecasts and trends can help us manage our business and quickly see whether there are steps that we can take to improve business profits.
Reopening the example CFO dashboard
We are going to start with the Sales Analysis sheet of Executive Dashboard.qvw from the examples we downloaded when we installed QlikView. If it is not open, please open it now, and navigate to the Sales Analysis tab:
Open QlikView if it is not open already.
Using the File | Open menu in QlikView, navigate to the Program Files| QlikView | Examples | Documents folder and double-click on Executive Dashboard.qvw to open it.
Select the fourth tab: the Sales Analysis tab.
Scroll down to the Charts displayed at the bottom of the tab.