Creation of QVD Files

[#1]

Hi,

I am quite new to this QlikView, I am going through the document I am not sure how to create a QVD file using excel file. I have one excel file test.xls on the desktop and want to create QVD file of that excel.

Could you pls suggest with the commands as I couldn't find in the document.

Thanks,

[tresesco]

Use the following :

Mytable:

Load * from .........xls;

STORE Mytable INTO <path>table.qvd;

[#3]

Thanks Tresesco for the quick response, I followed the same syntax I couldn't get any error messages but while loading its showing 0 lines fetched.

This is the way I worked, pls let me know where I am missing

Step 1: I have created one excel file on the desktop with the name of test in excel file

Step 2: Then I gone to the Edit Script in QlikView below is the script which I used

Mytable:

Load * from test.xls;

STORE Mytable INTO C:\Documents and Settings\raju.mtr\Desktop\table.qvd;

While reloading its asking me to save the file and I saved with testing on the desktop.

And I clicked on the reload its showing 0 lines fetched.

Step 3: I created one object with Table box. while creating its showing some different language in available fields.

I am not sure how to proceed further.

Pls suggest if any mistake in the script.

Thanks,

[suniljain]

Your Data is in which Sheet ?

I mean Sheet1,.........

[#5]

Sunil which sheet you are asking??

Thanks,

[sunil2288]

HI Tim

It is so simple to create an Qvd. After loading of data from xls.

just click on table files button and go to the desired path where ur Xls file is present .

Then click on next --> up to finsh the load window.

Create a folder to save your Qvds. Remeber the folder should be in the same location where this .Qvw application is present.

Then below arite a statement

Store <table Name> into <path>

then you can use this qvds in other .Qvw analysis application wherever you need it ..

Regards

Sunil.

[suniljain]

Your have excel have multiple sheet or what ?

If Multiple then data is in which sheet.

You have to use a sheet where data exist.

[sunil2288]

Hi Sunil

Your right ..

Tim

You have to select the sheet while loading the data you can find the option while loading the Table file.

Regards

Sunil

[tresesco]

When you load the excel sheet, use the total path to fetch it. Better you do this way:

Go to edit script: There you would find "Data From Files" grouping and a tab "Table Files.." tab. From there you have to browse your target file. Then the full path would be in the script. I think this would solve your problem. Ultimately the path and some more details of your excel sheet is required in your load statement like:

load * from

(ooxml, embedded labels, table is Sheet1);

I think this would help you.

[#10]

Hi,

Check this sample application.

Regards