topic problem with PEEK command on QVD in QlikView

problem with PEEK command on QVD

Tue, 02 Nov 2010 10:49:54 GMT

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?

problem with PEEK command on QVD

sathishkumar_go — Tue, 02 Nov 2010 11:39:27 GMT

Its working.

check this qvw application.....

-Sathish

problem with PEEK command on QVD

jonathandienst — Tue, 02 Nov 2010 11:41:16 GMT

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

problem with PEEK command on QVD

Tue, 02 Nov 2010 12:05:04 GMT

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

problem with PEEK command on QVD

Tue, 02 Nov 2010 13:00:29 GMT

Thanks, it is working.

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

thanks