topic How to Combine multiple QVWs into a single QVW? in QlikView

How to Combine multiple QVWs into a single QVW?

dmohanty — Tue, 02 Jul 2013 06:47:56 GMT

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.

Re: How to Combine multiple QVWs into a single QVW?

kaushiknsolanki — Tue, 02 Jul 2013 07:00:26 GMT

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

Re: How to Combine multiple QVWs into a single QVW?

dmohanty — Tue, 02 Jul 2013 07:06:58 GMT

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.

Re: How to Combine multiple QVWs into a single QVW?

kaushiknsolanki — Tue, 02 Jul 2013 07:18:01 GMT

Hi,

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

Meaning

App2 = App1 + App2

App3 = App3 + App2

.....

Like wise

Regards,

Kaushik Solanki

Re: How to Combine multiple QVWs into a single QVW?

Tue, 02 Jul 2013 07:21:14 GMT

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.

Re: How to Combine multiple QVWs into a single QVW?

dmohanty — Tue, 02 Jul 2013 07:26:25 GMT

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.

Re: How to Combine multiple QVWs into a single QVW?

dmohanty — Tue, 02 Jul 2013 07:28:12 GMT

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

Regards.

Re: How to Combine multiple QVWs into a single QVW?

Tue, 02 Jul 2013 07:35:59 GMT

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.

Re: How to Combine multiple QVWs into a single QVW?

dmohanty — Tue, 02 Jul 2013 08:06:56 GMT

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.

Re: How to Combine multiple QVWs into a single QVW?

Tue, 02 Jul 2013 08:30:51 GMT

Do u have Qlikview server and Publisher?

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

Regards.

Re: How to Combine multiple QVWs into a single QVW?

rajni_batra — Tue, 02 Jul 2013 11:46:59 GMT

You can create 1QVW with all 11 transaction tables from QVWs concatenated in one in dtaa model and then use same GUI.

Re: How to Combine multiple QVWs into a single QVW?

dmohanty — Tue, 02 Jul 2013 15:18:10 GMT

Hi Kaushik/Mohit,

Thanks for a feasible solution.

In all my QVWs, the data model script and all the table structure are same. So when I do a Binary Load as suggested, will it not form Synthetic keys?

As I am facing the same problem. Will the Binary approach work if all the QVWs have the exact same script?

Regards.

Re: How to Combine multiple QVWs into a single QVW?

luciancotea — Tue, 02 Jul 2013 15:33:01 GMT

OK, you have one QVW developed for a single region. But you have in fact 11 Regions. Right?

The result should be all regions data in one QVW and one more field in the interface: Region.

If that's the case, you need to add the Region dimension in one of the tables (where it makes most sense) and make sure that all your keys (links between the tables) contains the "Region" info: LOAD autonumber(OLD_ID, Region) as ID;

So, when you select one Region, the section will propagate through all the tables in your schema.

Re: How to Combine multiple QVWs into a single QVW?

Wed, 03 Jul 2013 06:11:28 GMT

can u try this?

below script is used to load the qvd files from different folder.

Set vConcatenate = ;
sub ScanFolder(Root)
          for each FileExtension in 'qvd'
                    for each FoundFile in filelist( Root & '\*.' & FileExtension)
                         if(wildmatch(FoundFile,'Invoice_tab*'))
                              FileList:
                              $(vConcatenate)
                              LOAD *, '$(FoundFile)' as SourceFile
                              FROM [$(FoundFile)] (qvd);
                              Set vConcatenate = Concatenate;
                         end if
                    next FoundFile
          next FileExtension
          for each SubDirectory in dirlist( Root & '\*' )
                    call ScanFolder(SubDirectory)
          next SubDirectory
end sub
Call ScanFolder('D:\qvd\Region') ;

Like that u can add the all the qvd in to one qvw file, so that all region comes under one qvw file.

Regards,

Kabilan K.