topic How do I create a variable from 2 different data sources in my load script? in QlikView https://community.qlik.com/t5/QlikView/How-do-I-create-a-variable-from-2-different-data-sources-in-my/m-p/1078871#M637039 <HTML><HEAD></HEAD><BODY><P>One of the things I really appreciate about QlikView is the ability to work with data from different sources.&nbsp; 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.&nbsp; 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.&nbsp; So I need to multiply the revenue times (the zone Circulation divided by the total Circulation).&nbsp; I want to see the revenue for each zone.</P></BODY></HTML> Tue, 15 Mar 2016 14:21:30 GMT 2016-03-15T14:21:30Z How do I create a variable from 2 different data sources in my load script? https://community.qlik.com/t5/QlikView/How-do-I-create-a-variable-from-2-different-data-sources-in-my/m-p/1078871#M637039 <HTML><HEAD></HEAD><BODY><P>One of the things I really appreciate about QlikView is the ability to work with data from different sources.&nbsp; 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.&nbsp; 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.&nbsp; So I need to multiply the revenue times (the zone Circulation divided by the total Circulation).&nbsp; I want to see the revenue for each zone.</P></BODY></HTML> Tue, 15 Mar 2016 14:21:30 GMT https://community.qlik.com/t5/QlikView/How-do-I-create-a-variable-from-2-different-data-sources-in-my/m-p/1078871#M637039 2016-03-15T14:21:30Z