Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Unavailable fields.

Hi

Im just beginning with qvd but there is one problem as i reload some my fields and are unavailable.  could someone please explain to me why this is as such?

6 Replies
jagannalla
Valued Contributor III

Unavailable fields.

Please check whether your qvd file is created properly with data or not. While selecting qvd file from qvw file -> edit script it will pop up File Wizard: Check whether your fields are existing or not.

Not applicable

Unavailable fields.

Jagan here is a sample of a table i tried to QVD so i just would like to know if its correct. Because it still seems to reload unavailable fields.

LOYTRYN:

LOAD @1 as BranchNo,

     @2 as TransactionDate,

     (Date(Date#(@2,'YYYYMMDD'),'DD/MM/YYYY')) as %_DateKey,

     @3 as MemberNo,

     @4 as Reference,

     @5 as Line,

     @6 as StockCode,

     @7 as BarCode,

     @8 as Nappicode,

     @9 as Department,

     @10 as Description,

     @11 as Bin,

     @12 as Quantity,

     @13 as Sales,

     @14 as LineValue,

     @15 as PointsPeriodNo14,

     @16 as PromoPoints,

     @17 as Sponsor,

     @18 as PointsType,

     @19 as PointsValue,

     @20 as PromoFactor,

     @21 as PromoPointType,

     @22 as PromoPointValue,

     @23 as NetItem,

     @24 as CardCode,

     @25 as Comment

FROM

LOYTRN_Durbell.CSV

(txt, codepage is 1252, no labels, delimiter is ',', msq);

store LOYTRYN into C:\QVD'S\LOYTRN_Durbell.CSV.qvd(qvd)

jagannalla
Valued Contributor III

Unavailable fields.

Your script looks perfectly. Can you add semicolumn at the end of qvd generation.

store LOYTRYN into C:\QVD'S\LOYTRN_Durbell.CSV.qvd(qvd);

otherwise can you share your qvw file with sample csv file.

Not applicable

Unavailable fields.

leni_balakrishn
Contributor III

Unavailable fields.

If possible, please share the screenshot of the error...

Not applicable

Re: Unavailable fields.

hi here is a screen shoot. hope its good enough