topic Re: How to delete a qvd file in QlikView

How to delete a qvd file

Tue, 02 Jun 2015 13:20:13 GMT

Hello,

Someone can tell me how to delete a qvd file?

Maybe something like: drop file '...\file_name.qvd'

Thank you very much.

Tue, 02 Jun 2015 13:24:08 GMT

I've tryed: EXECUTE '...\Etape1.qvd' (qvd);

but it didn't work.

maxgro — Tue, 02 Jun 2015 18:04:51 GMT

DIRECTORY;

t2: load rowno() as id autogenerate 100;

store t2 into t2.qvd (qvd);

EXECUTE cmd.exe /c del /q t2.qvd;

more detail here

ramoncova06 — Tue, 02 Jun 2015 18:08:00 GMT

can I ask what do you want to delete the QVD ?

It would probably be better if you did this outside of QV and use a scheduler/bat file for windows maintenance

Wed, 03 Jun 2015 09:29:19 GMT

Thank you very much, with this method, it pop up a probleme of security.

But thank you all the same.

Anonymous — Wed, 03 Jun 2015 09:36:09 GMT

Why don't you delete the QVD file where it stores to and then comment out your store into script and then reload again.

Wed, 03 Jun 2015 09:40:42 GMT

You are right, but I just don't want to delete it myself .

maxgro — Wed, 03 Jun 2015 09:48:58 GMT

I think a warning, if you check this but usually it works (desktop and server)

Siva_Sankar — Wed, 03 Jun 2015 09:54:22 GMT

You need to allow Script (Allow Database Write and Execute Statements) in User Preferences/Security tab.

Siva_Sankar — Wed, 03 Jun 2015 09:55:18 GMT

PFA