In our previously loaded sample data from Chapter 1, Getting That Financial Data into QlikView, sales is a grouping in the AcctGroup column and is a credit. It comes directly from the source system as a negative so that, when everything is summed up, we get a trial balance. That is why we could see the out of balances in our first tab. Sales will have to be multiplied by minus one (-1) in order for it to appear as a positive number. Also, we would like to have a target number to compare with Sales.
There are two additional sample data Excel spreadsheets available for download from your account at http://www.PacktPub.com that are used in this chapter. One is named
Target.xls and the other is named
Our target ...