Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview not reading QVD data

Hi,

I am just a week into Qlikview so don't have that in depth knowledge.

But have recently come up with something.

I am creating this basic qlikview application where i am reading data from two databases

1) Salary

2)Quarter

I am able to read data from my salary excel sheet whereas i created a qvd file from my quarters excel sheet and loaded both of them.

But after loading i cannot find any data or fields from the Qvd file whereas Salary sheet is working fine.

Is there any line of code i have to add for the qvd file to work. I have attached the QVW and the excel sheets.

Kindly assist,

Regards,

Rahul

ps: Both the tables are not related by any means and are for practice purpose.

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

Hi Rahul,

Check attachment.

Also for reading as qvd do like below  and read this table as qvd

Quarters:

LOAD Month,

     Quarter,

     Sales,

     Target

FROM

C:\Users\asaini\Desktop\Quarters.xlsx

(ooxml, embedded labels, table is Q_1);

Store Quarters into give_Path\Quarters.qvd;

Drop table Quarters;

Thanks,

AS

View solution in original post

13 Replies
Not applicable
Author

Hi

PFA and check on your system.

Regards

Not applicable
Author

QlikView file as well.

amit_saini
Master III
Master III

Hi Rahul,

Check attachment.

Also for reading as qvd do like below  and read this table as qvd

Quarters:

LOAD Month,

     Quarter,

     Sales,

     Target

FROM

C:\Users\asaini\Desktop\Quarters.xlsx

(ooxml, embedded labels, table is Q_1);

Store Quarters into give_Path\Quarters.qvd;

Drop table Quarters;

Thanks,

AS

Not applicable
Author

Hey Sumita,

Thanks for your wonderful reply and the code is working fine now.

As am a newbie and this being my learning curve, please let me know any reason why it wasn't working in the first place. Was there any additions from your end.

Did I miss something while loading data.

Thanks again

Regards,

Rahul

Not applicable
Author

Hey Amit,

Thanks for your reply.

A few things I would like to know like  first time when I tried with Qvd alone it didnt funtion but when I loaded the xls sheet it did respond so any reason it happened that way or was there a fault from my side.

I am getting a bit confused in knowing the way a Qvd works.

Thanks again for your helping hand.

Regards,

Rahul

amit_saini
Master III
Master III

Rahul,

First you need to call data from source file , in your case it is Excel sheet. After loading this excel convert this data into QVD file and now instead of calling excel you can call this qvd for your purpose.

Thanks,

AS

amit_saini
Master III
Master III

Also please check this link -> How you can load a QVD into your application.

http://community.qlik.com/message/680130#680130

Thanks,

AS

Not applicable
Author

Hi Amit,

I just gave a try to the binary load but after removing the QVD code and then while loading it is showing an error saying

I have assured the Binary load line is the very first line of the main.

It is giving the same error also with the qvd code included.

Is it that it (binary load) works predominantly with QVW files only or is it any thing else.

Thanks and regards,

Rahul

amit_saini
Master III
Master III

Looks like your qvd is in some other format make it default as QlikView file. Yes Binary will work with QVW only.

Thanks,

AS