Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

data from one qvw(not qvd) to other

Hi Experts,

Is it possible to get data from one qvw(not qvd) to other qvw file or combine two qvw files...???

if so, how to do that....

any script for that?????????

pls guide me

9 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi,

you can load the data, but NOT layouts etc, by using a BINARY LOAD, you cannot load from a qvw with section access and can only process one binary load in a QVW

HTH Andy

sgrice
Partner - Creator II
Partner - Creator II

You can binary load all the data from one document into another

binary [someotherdoc.qvw];

This has to be the very first statement of your script before anything else

Combining is not possible directly but you can output every table in a qvw by binary loading it and then having a store for each table in the document

store tablea into tablea.qvd(qvd);

ankit777
Specialist
Specialist

hi,

Check this link

Binary Load

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

You can load 1st qvw file as Binary load and the 2nd load can be as normal.

buzzy996
Master II
Master II

Is it possible to get data from one qvw(not qvd) to other qvw file or combine two qvw files...??? yes,it's  possible.

if so, how to do that....

any script for that????????? --

1.try to create fresh qvw document,

2. edit script---Data tab--select QlikView file (from here u can select ur qvw or qvd)

3. repeat 2nd step to selct another either qvw or qvd

4. save and load

Not applicable
Author

Hi,

use Binary Load as shown in the below scripting;

Capture.PNG

Here I have loaded Maps.qvw through Binary load and other table as normal

Regards

Not applicable
Author

thanks for the reply.

is it possible to load a particular table frome one qvw to other??

buzzy996
Master II
Master II

yes,u can do.

IAMDV
Luminary Alumni
Luminary Alumni

Binary load as suggested by everyone and drop the tables you don't need. This way you can keep what you need. You can use functions like NoofTables(), TableName() and TableNumber() to automate this process.

Cheers,

DV

www.QlikShare.com