topic Linking two Qlikview applications in QlikView

Linking two Qlikview applications

Wed, 11 Dec 2013 15:31:57 GMT

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

Re: Linking two Qlikview applications

datanibbler — Wed, 11 Dec 2013 15:36:12 GMT

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

Re: Linking two Qlikview applications

djsampat — Fri, 14 Nov 2014 01:32:13 GMT

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?