I am trying to find out the best way to link two Qlikview applications.
Here is my scenario: I have one Qlikview application that is primarily focused on sales and another one that is focused on financials from the GL. The financial application uses a lot of variables in pivot tables to arrive at at the appropriate values for total sales, COGS etc with current period, prior period calculations built into set expressions.
I need to borrow some of these variables into my Sales application and do not want to reinvent the wheel.
What would be the best way to achieve this?
My initial option of a binary load did not work since that only loads the data model and data but not the variables. Any other options that members can suggest?
make your variables "global" by storing them in qvs_files - those can be INCLUDEd in the script (that's the command). Take care, though: In the script, you cannot use set_analysis, so if the variables include some set_analysis, that won't work and you will have to re-create them.