topic Re: Creating QVD in QlikView

Creating QVD

ksasidhars — Tue, 05 Feb 2013 22:25:55 GMT

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

Re: Creating QVD

mohanrajsubrama — Wed, 06 Feb 2013 08:47:07 GMT

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

Re: Creating QVD

er_mohit — Wed, 06 Feb 2013 08:49:49 GMT

hiii

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

Re: Creating QVD

Wed, 06 Feb 2013 08:51:44 GMT

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