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.
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.qvwto open it. - Select the fourth tab: the Sales Analysis tab.
- Scroll down to the Charts displayed at the bottom of the tab.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.