Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to clean a QVD without calling Modules or external program's

On Edit Script:

.................

Sub EmptyQvd(file)

if (not IsNull(QvdCreateTime(file)) and QvdNoOfRecords(file)>0) then

     LET vFieldName=QvdFieldName(file,1);     

     ___:noconcatenate LOAD * FROM [$(file)] (qvd) WHERE 1=0;

     STORE ___ INTO [$(file)] (qvd);

     DROP TABLE ___;

end if

End Sub

...................

call EmptyQvd('file to delete.qvd');

Labels (1)
0 Replies