Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Linking two Qlikview applications

Hello,

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?

Thanks,

Sethu

2 Replies
Highlighted
Champion
Champion

Hi Sethu,

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.

HTH

Best regards,

DataNibbler

Highlighted
Creator II
Creator II

Sethu, did you manage? Please upload a sample file. I have the same requirement.

DataNibbler, Can you give a Sample of what your qvs would look like?