topic COMBINING MULTIPLE QLIKVIEW FILES INTO 1 !!!! (HELP) in QlikView

COMBINING MULTIPLE QLIKVIEW FILES INTO 1 !!!! (HELP)

Tue, 12 Apr 2011 17:29:47 GMT

HELLO FRIENDS!!

I'm facing a problem!

I have 3 qlikview files, each with its own data.

My problem is, combining these 3 qlikview files into 1 qlikview file.

I know this can be done by taking the load script of the other files and putting inside my main file's load script, but is there an alternate way ??

Basically,

1) 3 Qlikview files named as SONY, DELL, PANASONIC.

2)Each Qlikview file has its own data.

3)Create a way in which, in one qlikview file, i can read this 3 Qlikview files data.

4)Maybe in a list box, have this 3, SONY,DELL,PANASONIC.

5)When click either one, that file must be read, and the data as well.

Thanks! I'll try get sample data to further clarify any doubts.

COMBINING MULTIPLE QLIKVIEW FILES INTO 1 !!!! (HELP)

Tue, 12 Apr 2011 17:46:58 GMT

Take a look in the documentation at QVD files. In the loadscript, you can write out data from a QlikView table into a QVD file. For example, to write out data from SONY_SALES table into a qvd file you would code this in the loadscript:

Store SONY_SALES into QVD_SONY_SALES.qvd (qvd);

Do something like that for all of the major tables in your three documents. Then, in a fourth document you can read in all of the qvd files on disk. If you take care with how you name them you can read them in with a wildcard character like an asterisk. For example, to consolidate the example sales data you might code this:

CONSOLIDATED_SALES:

Load * from QVD_*_SALES.qvd (qvd);

COMBINING MULTIPLE QLIKVIEW FILES INTO 1 !!!! (HELP)

Wed, 13 Apr 2011 04:53:43 GMT

HELLO AGAIN! I GOT 2 FILES NOW! COULD YOU HELP ME WITH THAT QVD DOCUMENT? I'M NOT REALLY SURE ON HOW TO GO ABOUT DOING THAT. THANK YOU!!

Try this 2 files first.

If it works, then i can continue with all my other documents myself. THANK YOU FRIENDS! 😄

COMBINING MULTIPLE QLIKVIEW FILES INTO 1 !!!! (HELP)

Wed, 13 Apr 2011 04:55:35 GMT

OKAY, THE PREVIOUS FILE WAS Nilesh_Ver_SMACKDOWN.This is Nilesh_Ver_RAW.

So, could you synchronise both together into one by the QVD format, and show it into one file? Is that possible?

Thanks for your help!

😄