How to Combine multiple QVWs into a single QVW?

[dmohanty]

Hi All,

Incase I have 2 QVWs (let 2 as of now) with data for two different Regions, Suppose for 1st QVW, Region = IND and for 2nd QVW, Region = USA. Both the QVWs have same data model script and same GUI. Only data is different.

Now I want to combine these QVWs into a single QVW, so that in the new QVW I can have a single List Box as Region which would show a list of regions and also the same GUI as like individial QVWs. If I would select IND, the QVW should show data for IND and if I select USA, QVW should show data for USA. I can select multiple Regions as well.

Similarly I have 11 QVWs. Now I need to know the approach on how to combine into a single one? Please help in providing the steps and approach.

Regards.

[kaushiknsolanki]

Hi,

     All you need to do is open anyone of the application. Say the application name is App1

     At at the start of the script (i.e at first line) type

     Binary C:\App2.qvw;

     and reload the application.

Regards,

Kaushik Solanki

[dmohanty]

Thanks Kaushik for the quick help.

Incase I have multiple files, how to approach? As only one Binary command is allowed in a single QVW. I need to combine 11 QVWs now. What would be the best possible way?

Please suggest.

Reagrds.

[kaushiknsolanki]

Hi,

     The only way is you combine the apps one by one.

     Meaning

     App2 = App1 + App2

     App3 = App3 + App2

     .....

     Like wise

Regards,

Kaushik Solanki         

[#5]

Hi dmo,

How did u create a 11 qvw files?

is source same for this all qvw files?

if source is same u can load the all region into qvw file.

Regards,

Kabilan K.

[dmohanty]

Hi Kabilan,

I have different sources. Let say for 1st QVW, QVDs are stored in IND folder. for 2nd QVW, QVDs are stored in USA folder, for 3rd QVW, QVDs are stored in UK folder and so on...QVDs for different regions have similar structure but data are different.

So I need consolidate all 11 QVWs into one.

[dmohanty]

Thanks Kaushik for the suggestion. I will try this approach. Please do let me know if you come across any other possibilities.

Regards.

[#8]

How did u save the qvds name? eg Invoice_tab

then Y did u save the qvds in different different folder?

Y don't u save the qvd like below in same folder?

InvoiceTab folder:

Invoice_Tab_IND

Invoice_Tab_USA

etc,

then we can load these qvd in to single qvw like below.

Load  * From Invoice_Tab*.qvd(qvd);

Hope u understand this.

Regards,

Kabilan K.

[dmohanty]

Hi Kabilan,

Thanks for some suggestions. You are right even that all QVDs for different regions have same name and structure.

But purpose of storing in separate folders is that I have to create 11 individual QVWs for users also. and those 11 QVWs will be consolidated in to a single one as well as a separate requirement.

Regards.

[#10]

Do u have Qlikview server and Publisher?

With this, we can separate the application as per region.

Regards.