topic How to know if a qdv exist? in QlikView

How to know if a qdv exist?

Tue, 03 Aug 2010 15:09:16 GMT

Hello there!

Anybody know how can I ask in a script if a file (qvd) exist?

Thanks a lot!!

regards.

martin59 — Tue, 03 Aug 2010 15:11:57 GMT

Hi,

You can try with that :

IF FileSize('MyTable.qvd') > 0 THEN
 SET QVD_EXISTS=1; // true
ELSE
 SET QVD_EXISTS=0; // false
END IF

Tue, 03 Aug 2010 15:34:52 GMT

If you are talking about in a QV script we tend to use

QvdCreateTime

('$(cFileName)') >= 0

Tue, 03 Aug 2010 15:43:26 GMT

It's working well.

Thanks again.

hector — Tue, 03 Aug 2010 16:15:14 GMT

Hi, also works QvdNoOfRecords(qvdfile.qvd)

if is null, the qvd file doesn't exist

rgds

Wed, 04 Aug 2010 00:36:05 GMT

I could figured out after read your answers we can validate if a qvd file exist using differents scripts file functions.

i.e: QvdNoOfRecords, QvdCreateTime, FileTime, FileSize;

Thanks.

regards.