0 Replies Latest reply: Mar 15, 2016 10:21 AM by Alicia Baker RSS

    How do I create a variable from 2 different data sources in my load script?

    Alicia Baker

      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.