Multiple qlikview files

[#1]

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

[#2]

sorry,

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

Greets

[#3]

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

[Oleg_Troyansky]

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.

[Miguel_Angel_Baeyens]

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).

[#6]

<!-- -->

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

<em style="color: #808080; font-size: 10pt;">vTableName</em>= TableName(<em style="color: #808080; font-size: 10pt;">$(i)</em>);

LET

<em style="color: #808080; font-size: 10pt;">vOutfile</em>= '$(vTableName).qvd';

STORE

INTO (qvd);

NEXT i

[#7]

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

[#8]

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.