Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Multiple qlikview files

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

7 Replies
Not applicable

Multiple qlikview files

sorry,

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

Greets

Not applicable

Multiple qlikview files

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

Multiple qlikview files

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

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

Not applicable

Re: Multiple qlikview files

<!-- -->



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 D: 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


Not applicable

Re: Multiple qlikview files

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 D: 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

Not applicable

Re: Multiple qlikview files

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.

Community Browser