Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-11-15 11:22 AM

Pivot table variance Actuals vs Forecasted

I am trying to create a difference between Actuals and Forcasted amounts in Qlikview. This is very easy to do in excel but I am trying to create this in a pivot table in QV. Basically each month we have actuals and forecast and we need to do a difference to see what the amount is between the two. Also ideally at the end we would like to see a total for actual and forecast and a total difference calculated. I have attached the ideal scenario. Any suggestions on how to make this work?

error loading image

2,282 Views
0 Likes
10 Replies
Not applicable
‎2010-11-15 03:02 PM
Author

In response to

Í don´t know if you´ll like it, but I just a copy of that report (if you want) and change line dimension into rows and get out month dimesion (or move it). I would´t do anything else.

Fiber

76 Views
0 Likes