How do I create a variable from 2 different data sources in my load script?
One of the things I really appreciate about QlikView is the ability to work with data from different sources. The qvw I am working with right now is looking at data from a Production System where I get the data about zone Circulation and looking at data from a Front End System where the billing is done. The Front End System only contains the total Circulation. I need to create a variable that contains the revenue for a zone of the total Circulation. So I need to multiply the revenue times (the zone Circulation divided by the total Circulation). I want to see the revenue for each zone.