Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ksasidhars
Creator
Creator

Creating QVD

I want to load a QVD with all the needed fields from multiple tables in my script. Is it possible and how to do that. Please let me know. Thanks - Sasi

3 Replies
mohanrajsubrama
Contributor II
Contributor II

Hi Sasi,

            After you making Qvd and call all the required  Qvd's to ur Application as per ur requirements later if u missed 1 or 2 coloumns u can go to edit script and add the column and reload the application .

           Then u can see ur added coloumns also there.

hope this help

regards,

Mohanraj Subramanian

er_mohit
Master II
Master II

hiii

a:

load table from xls.

then

store a into c/user/desktop.qvd;

means

store tablenae into pathname.qvd;

then reload after that del. the tables

and load table file from qvd where you give the path.then

when you loadind the tables from qvd in qlikview using table file then it shows the option next and again it gives enable transformation step to click on that escape it and go further next then you can got table fields with cross sign and those fields which are not required you can del. that

see the image attach

Not applicable

hi

LOAD customer,

     salary

FROM

(ooxml, embedded labels, table is Sheet1);

STORE Sheet1 into ;

then ctrl E

clik on tables files

then add qvd file.

then you get all fields of qvd file