homee
Contributor III
2020-03-02
10:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to match Forecast with Actuals Data
Hi Qlik Community,
for the financial reporting i want to compare actuals with forecast. We are getting orders (many many per day) and we have a monthly target. So i have a table with the forecast data that consists of the revenue which always occurs on the first os each month. And a i have that huge table with all orders inside. Now i have two variables fc_date and Date (which is from my master calendar). If i now put everything in the analysis fc_date is not matched to Date, which is a problem for the visualization and also if i use the calendar field. In the picture it is also gruouped by our channels. If i change anything in the date field only the actuals respond to that and the forecast revenue in the graph is totally off...
- Tags:
- master calendar
0 Replies