topic Re: How delete the qvd file. in QlikView

How delete the qvd file.

Mon, 13 May 2013 05:37:53 GMT

Hi All,

Do you know how to use QV script to delete the QVD file?

Thanks.

Re: How delete the qvd file.

prasad_dumbre — Mon, 13 May 2013 05:40:55 GMT

I guess, you have to use Macro for it . . .

Re: How delete the qvd file.

rwunderlich — Mon, 13 May 2013 06:05:13 GMT

First, consider that a STORE statement will overwrite the existing QVD file.

To specifcally delete the qvd file, try an EXECUTE script statement.

EXECUTE CMD.EXE /C del "myqvd.qvd";

-Rob

http://robwunderlich.com

Re: How delete the qvd file.

qlikviewforum — Wed, 08 Jan 2014 13:20:29 GMT

Thank you Rob!

It is throwing secutiry alert as we didn't set the EXECUTE flag for script for not been set. Could you please help me out to set the same.

Re: How delete the qvd file.

Wed, 08 Jan 2014 13:35:35 GMT

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

Re: How delete the qvd file.

psankepalli — Thu, 25 Jun 2015 16:08:17 GMT

Open the QVW file -> Settings -> User Preferencs -> Security -> Check Script (Allow Database Write and Execute Statements) . Click OK and apply. Save the Document. then it won't prompt security message.

Re: How delete the qvd file.

Anonymous — Wed, 17 May 2017 16:07:03 GMT

Stefan Walther has a great discussion about it here ; he reviews three techniques.

Delete the files with a macro called from the load script

Delete the files by executing a batch statement

Use a pure load-script statement without giving your script system-access and empty the QVD-files within your load-statement

Notice other answers here have already addressed

technique 2 (Rob's answer; EXECUTE CMD.EXE /C del "myqvd.qvd";),
technique 1; (Prasad's answer; use a Macro (more specifically by creating a Scripting.FileSystemObject with the CreateObject function) Set objFSO = CreateObject("Scripting.FileSystemObject") )

But Stefan prefers the 3rd technique.

Remember as Sean and Prasanna say, you may need to change security settings:

Re: How delete the qvd file.

carlcimino — Wed, 09 Aug 2017 17:21:30 GMT

I updated my security settings and wrote my execute statement. It still throws this message and makes me click Override. The script finishes but doesn't delete the file. What am I missing?

EXECUTE CMD.EXE /c del c:\QlikView\Scorecard\Premium Fact\PremFact.qvd

Re: How delete the qvd file.

Anil_Babu_Samineni — Wed, 09 Aug 2017 17:23:51 GMT

May be double quotes missed for your path

Re: How delete the qvd file.

carlcimino — Wed, 09 Aug 2017 17:29:14 GMT

DUR! Thanks!

Re: How delete the qvd file.

carlcimino — Wed, 09 Aug 2017 17:39:17 GMT

Any way to get rid of the Security Alert window? I already changed my user settings closed the app and reopened.

Re: How delete the qvd file.

Anil_Babu_Samineni — Wed, 09 Aug 2017 17:43:41 GMT

And check from script bottom preview there also you need to enable the option

Re: How delete the qvd file.

denniste — Thu, 26 Apr 2018 08:00:16 GMT

I use the script below to empty a QVD file. This works efficiently even for large QVDs.

Sub EmptyQvd(qvdFilePath)

TRACE --;

TRACE Start EmptyQvd for file $(qvdFilePath);

// First check if the qvd-file exists

if (not IsNull(QvdCreateTime(qvdFilePath))) then

TRACE ... file exists ...;

// Check if the Qvd-file contains more than 0 records

if(QvdNoOfRecords(qvdFilePath) > 0) then

tmp_qvd_table:

NoConcatenate

load *

where 1=2;

first 1

load *

from [$(qvdFilePath)](qvd);

store tmp_qvd_table into [$(qvdFilePath)](qvd);

Drop table tmp_qvd_table;

end if ;

else

TRACE ... file '$(qvdFilePath)' does not exist;

end if;

TRACE finished EmptyQvd;

TRACE --;

End Sub

;

Re: How delete the qvd file.

dhasharadh — Wed, 31 Oct 2018 16:02:16 GMT

is there any way to delete the Qvd without using a macro or a Bacth job in windows...

we know that we can empty the Qvd in the script without using a Macro or Batch job in windows, but we are looking for an option to delete the full Qvd... ???

please let me know if any such option is there.... thanks much !!