topic Multiple qlikview files in QlikView

Multiple qlikview files

Tue, 07 Jul 2009 18:04:02 GMT

Hi there is it possible to load 2 or more qlikview (.qvw) files?

when I try in the editor with the button Qlikview Files... in the Data from Files panel and I load 2 files

in edit script it goes like this for 1:

Binary d:\qlikview\prova\xx\prova_1.qvw; (and loads it)

like this for 2:

1 Binary d:\qlikview\prova\xx\dist.qvw;
2 Binary d:\qlikview\prova\xx\prova_1.qvw; (and loads only the 1st one)....

......

with 2 files it gives an error "...unknown statement...\\...prova_1.qvw" nad loads only data from first file

P.S. both files are working perfectly when opened singularely.

thanks for help.

Alex

Multiple qlikview files

Tue, 07 Jul 2009 18:09:03 GMT

sorry,

at the moment you only can load one qvw-file by binary load.

Greets

Multiple qlikview files

Thu, 25 Mar 2010 11:49:02 GMT

what a binary load ... and what the different with the load normal??

Multiple qlikview files

Oleg_Troyansky — Thu, 25 Mar 2010 12:38:15 GMT

Loading one QVW into another one is called a "binary load", and it's only available once. You can't load 2 QVW files into one.

The work around is to store a set of QVD files from your sources and then load them all into the target document and take care of all the identical field names and other data modeling issues.

Multiple qlikview files

Miguel_Angel_Baeyens — Thu, 25 Mar 2010 13:35:54 GMT

La carga binaria toma los datos (y datos de acceso) de otro fichero qvw (con el formato, nombre, estructura que tengan en ese fichero), y no de una base de datos normal (tal cual).

Re: Multiple qlikview files

Thu, 15 Dec 2011 17:04:24 GMT

Hi there ,

I'm quite new to QV. Can anyone help me to find out a way to import and merge 3 QW application into one.

I have them stored on 😧 drive.

D:\MMix 1980-2011

Global Model Mix 1980-2011 (2010-2011).qvw

Global Model Mix 1980-2011 (2000-2009).qvw

Global Model Mix 1980-2011 (1980-1999).qvw

BINARY myqvw.qvw;

FOR i = 0 to NoOfTables()-1

LET

vTableName= TableName($(i));

LET

vOutfile= '$(vTableName).qvd';

STORE

INTO (qvd);

NEXT i

Re: Multiple qlikview files

Thu, 15 Dec 2011 17:05:25 GMT

Hi there ,

I'm quite new to QV. Can anyone help me to find out a way to import and merge 3 QW application into one.

I have them stored on 😧 drive.

D:\MMix 1980-2011

Global Model Mix 1980-2011 (2010-2011).qvw

Global Model Mix 1980-2011 (2000-2009).qvw

Global Model Mix 1980-2011 (1980-1999).qvw

BINARY myqvw.qvw;

FOR i = 0 to NoOfTables()-1

LET vTableName = TableName($(i));

LET vOutfile = '$(vTableName).qvd';

STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);

NEXT i

Re: Multiple qlikview files

Fri, 22 Mar 2013 14:16:18 GMT

Amigo Lo que io hize fue hacer el mismo codigo:

BINARY /(directorios)/myqvw.qvw;

FOR i = 0 to NoOfTables()-1

LET vTableName = TableName($(i));

LET vOutfile = '$(vTableName).qvd';

STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);

NEXT i

Pero yo tambien lo necesitaba para mas de 2 archivos, por ende lo hise agregando el codigo en cada archivo que requeria. por ejemplo:

1- ArchCargaBd.qvw

2- ArchGestion.qvw

3- Archivo de Diseño (o principal)

lo que hise fue agregarle el codigo al Archivo de Diseño, que referencie mediante BINARY al Archivo " ArchGestion.qvw" y de la misma forma como el archivo de Gestion requiere se cargen las tablas de la Bd, dentro del archivo "ArchGestion.qvw" hago la referecia con BINARY al archivo "ArchCargaBd.qvw".

De este modo se pueden relacion mas de 2 archivos.