Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How do we delete the existing qvd in qlikview ?
Thanks in Advance
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
t2: load rowno() as id autogenerate 100;
store t2 into t2.qvd (qvd);
EXECUTE cmd.exe /c del /q t2.qvd;
Thanks for your reply @Massimo Grossi !!!! And i am expecting few more solutions
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
thanks Antonia Caria
Posts of Massimo ,Antonio works good
Thanks