I'm new to QlikView, we are trying it out for my company, to see if it can fulfill our need, up until now everything works fine, but I am currently stuck with an (apparently) very simple problem. Basically I'm trying compare the budget with the reality.
I have three excel files, which look like this :
name, zone = Europe, type = real, cat1, cat2, cat3, value
name, zone = America, type = real, cat1, cat2, cat3, value
zone, type = Budget, cat1, cat2, cat3, value
One line could be :
trip to Paris, Europe, real, costs, marketing, trip, 157
I load each file and then I do drill down.
What I need to do is to create a new column when loading the Budget file, named 'Difference', which would be the difference between the value of the budget line and the sum of every corresponding line from the other two table (same zone, cat1, cat2, cat3).
Also if two row of Budget are the same (except for 'value'), then they would need to be summed up.
Thanks a lot for your help, any lead or suggestion you can give me is very welcome !
Added dummy data, the yellow column in 'budget' is the column I which to add on load. Tanks a lot !