Binary load with Qvs

[krishna20]

Hi Folks,

I want to use single qvs file for multiple binary load statements that are referred to multiple presentation layers individually, is that possible?
Any workaround to achieve this ?

We all know that Qlik allows one only qvw or qvf in an app.

[venkat_thota]

Following this...I also has similar requirement.

I did see ODAG feature but seems its more of dynamic generation of apps

[morgankejerhag]

You cant binary load from multiple apps. What you can do is to have the apps store QVDs with the relevant data. Then read those QVDs into the final app.

[Manish_Kumar_]

Hey @krishna20 

Say You Have 2 apps Q1.qvw(or qvf) and Q2.qvw(or qvf)

And You have to take Binary from both these apps

POssible Solution Could be this-

Take Binary of Q1.qvw in Q2.qvw,

Now Q2.qvw will contain datamodel from both Q1 and Q2,which will serve your purpose.You can also create a new App Say Final.qvw taking binary from Q2.qvw which will also contain data of both Q1 and Q2

NOTE: Be Careful of Synthetic Keys and Circular Loops which could be created due to the association of 2 data models.

[krishna20]

May be I put my question in detail like below. I have to use only one qvs txt file to take multiple binary loads.

[marcus_sommer · Accepted solution]

A binary load must be the first statement. Therefore no conditional stuff could be applied which branched into different things. But the binary-statement could be extended by an existing variable so that the statement may look like:

binary path/datamodel$(var)

and var is stored within each presentation layer and contained the appropriate reference to its parent data-model.

- Marcus