topic Re: QVD Issue in QlikView

QVD Issue

VishalWaghole — Tue, 26 Jun 2012 07:36:19 GMT

Hi Guys

Please anybody tell me, How can we use 3rd rows as header row from QVD.

Like we use from excel as

(biff, embedded labels, header is 3 lines, table is [Canada & Asia actuals$]);

But i dnt knw how can from qvd, so please if anyone no then tell me.........

Thanks,

Vishal Waghole.

Re: QVD Issue

Miguel_Angel_Baeyens — Tue, 26 Jun 2012 10:04:28 GMT

Hi Vishal,

A QVD file stores only one table, so the header line should be the first one. Anyway, if you don't want to load the first 3 lines (for example), you can do as follows:

Table:
LOAD *
FROM File.qvd (qvd)
WHERE RecNo() > 3;

Hope that helps.

Miguel

Re: QVD Issue

VishalWaghole — Tue, 26 Jun 2012 13:16:54 GMT

Miguel,

But result is not come as same as when i extract Data by using Excel

Thanks,

Vishal

Re: QVD Issue

Miguel_Angel_Baeyens — Tue, 26 Jun 2012 13:36:18 GMT

Hi Vishal,

Well, Excel and QVD formats are completely different. Can you please elaborate on your actual requirement? Are you sure that the QVD has 3 header lines (which to me seems pretty unusual)?

Miguel

Re: QVD Issue

VishalWaghole — Tue, 26 Jun 2012 14:24:15 GMT

Hi Miguel

I attached here My Excel file image, from that excel i create d QVD. In Our QVW Application perviousely we used excel but now we want to replace that excel to qvd. In perviouse QVW thr is code

LOAD Region,

Category,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec

FROM

[Data.xls]

(biff, embedded labels, header is 3 lines, table is [Canada & Asia actuals$]);

that means header line is 3 without deleting 1st 2 line.

same logic i want for qvd which i created from data.xls excel.