problem with PEEK command on QVD

[#1]

Hi

I am new to Qlikview..

facing a peculiar problem. While loading DATA from XL sheet , Peek command is working properly but the same data if i am loading from a qvd file, Peek command is not working I am using the following code

MYTBL:

LOAD FYR,

QVNM

FROM

MYTBL.xls

(biff, embedded labels, table is Sheet1$);

LET Q=Peek('QVNM',3);

LET Q=Peek('QVNM',0);

LET Q=Peek('QVNM',1);

// above command are working properly

DROP TABLE MYTBL;

MYTBL1:

NOCONCATENATE

LOAD * FROM MYTBL.QVD (qvd);

// below 3 command are not working !!! (even if I remove MYTBL load commands TOTALLY)

LET Q=Peek('QVNM',3);

LET Q=Peek('QVNM',0);

LET Q=Peek('QVNM',1);

attaching qvd file ... Any idea?

[sathishkumar_go · Accepted solution]

Hi

Its working.

check this qvw application.....

-Sathish

[jonathandienst]

Hi

I have no problem running the script below with your QVD file:

MYTBL1:
LOAD * FROM MYTBL.QVD (qvd);

LET Q=Peek('QVNM',3);
LET Q=Peek('QVNM',0);
LET Q=Peek('QVNM',1);

The peek commands are working fine.

Jonathan

[#4]

Hi,

The second LOAD * does not show column names. Adding a WHERE (QVNM=1) or (QVNM=2) or (QVNM=3) will help exclude obvious reasons.

Once you ensured there is some data, remember that function has 3 parameters, and you have more tables.

peek( fieldname [ , row [ , tablename ] ] )

-Alex

[#5]

Thanks, it is working.

I hope something is wrong with my QVW file. I created a new application , it is working now

thanks