Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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.