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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Deleting qvd

   Hi All,

How do we delete the existing qvd in qlikview ?

Thanks in Advance

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

See: QlikTip #30: How to delete existing QVD files via load-script

public function DeleteFile(filePath)

   Set objFSO = CreateObject("Scripting.FileSystemObject")

   Dim retVal 'as Boolean

   If objFSO.FileExists(filePath) Then

      Call objFSO.DeleteFile(filePath)

      retVal = true

   Else

      Set objFSO = nothing

      retVal = false

   End If

   DeleteFile = retVal

end function

View solution in original post

5 Replies
maxgro
MVP
MVP

t2: load rowno() as id autogenerate 100;

store t2 into t2.qvd (qvd);

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

Anonymous
Not applicable
Author

Thanks for your reply @Massimo Grossi !!!! And i am expecting few more solutions

Anonymous
Not applicable
Author

See: QlikTip #30: How to delete existing QVD files via load-script

public function DeleteFile(filePath)

   Set objFSO = CreateObject("Scripting.FileSystemObject")

   Dim retVal 'as Boolean

   If objFSO.FileExists(filePath) Then

      Call objFSO.DeleteFile(filePath)

      retVal = true

   Else

      Set objFSO = nothing

      retVal = false

   End If

   DeleteFile = retVal

end function

Anonymous
Not applicable
Author

thanks Antonia Caria

Anonymous
Not applicable
Author

Posts of  Massimo ,Antonio works good

Thanks