Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How delete the qvd file.

Hi All,

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

Thanks.

13 Replies
carlcimino
Creator II
Creator II

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

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
denniste
Contributor II
Contributor II

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

;

dhasharadh
Creator III
Creator III

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 !!