topic Re: Qlikview not reading QVD data in QlikView

Qlikview not reading QVD data

Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: Qlikview not reading QVD data

Tue, 23 Dec 2014 07:24:06 GMT

PFA and check on your system.

Regards

Re: Qlikview not reading QVD data

Tue, 23 Dec 2014 07:26:43 GMT

QlikView file as well.

Re: Qlikview not reading QVD data

amit_saini — Tue, 23 Dec 2014 07:28:03 GMT

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,

Re: Qlikview not reading QVD data

Tue, 23 Dec 2014 09:22:05 GMT

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

Re: Qlikview not reading QVD data

Tue, 23 Dec 2014 09:34:20 GMT

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

Re: Qlikview not reading QVD data

amit_saini — Tue, 23 Dec 2014 09:40:06 GMT

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,

Re: Qlikview not reading QVD data

amit_saini — Tue, 23 Dec 2014 09:48:10 GMT

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

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

Thanks,

Re: Qlikview not reading QVD data

Tue, 23 Dec 2014 09:55:49 GMT

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

Re: Qlikview not reading QVD data

amit_saini — Tue, 23 Dec 2014 10:01:34 GMT

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

Thanks,

Re: Qlikview not reading QVD data

Tue, 23 Dec 2014 10:23:51 GMT

Amit Kindly can you let me know how can I change the qvd format as default as qlikview.

Thanks,

Rahul

Re: Qlikview not reading QVD data

amit_saini — Tue, 23 Dec 2014 10:49:55 GMT

Right click -> Open file with QlikView .

Thanks,|
AS

Re: Qlikview not reading QVD data

Tue, 23 Dec 2014 10:56:42 GMT

Hey thanks Amit,

Time with you really helped me.

Thanks a lot
Regards,

Rahul

Re: Qlikview not reading QVD data

amit_saini — Tue, 23 Dec 2014 10:59:13 GMT

My Pleasure brother

Thanks,
AS