topic How to create a blank .qvd ? in QlikView

How to create a blank .qvd ?

Mon, 18 Jul 2011 08:31:03 GMT

Hi All,

I have a problem.

I have to generate the qvd for a report date wise.

If the data is a working day , then the qvd specific to that date will contain data.

Otherwise a blank qvd must be there for that date.

Can anybody help me out ??

Thanks in advance !!!!!

erichshiino — Mon, 18 Jul 2011 12:24:35 GMT

Hi,

The following script will create a table with two fields but no rows, and store it in a file with the date as part of the file name.

Hope this helps,

Erich

let vToday = date(today(),'YYYYMMDD');
Table:
LOAD * INLINE [
    Field1, Field2
];
Store Table INTO Table$(vToday);