drop qvd

[#1]

Hello,

I am very new to Qlikview, can someone tell me how can i drop the qvd file using the script before loading the data on it.

Thanks in advance.

[#2]

qvd is nothing but a table

drop table tablename;                here tablename is the qvd name which u have given

[Anonymous]

Hi

If you want to delete the qvd from the folder

below is the code

vTempQVDPath = GetFolderPath()//Path of the QVD
EXECUTE cmd.exe /C del $(vTempQVDPath)\*.qvd;

you need ensure that "Can execute external programs" in script window

Regards

Harsha

[maleksafa]

if you just one to empty the qvd before loading new data in it, then there is no need to delete it, when loading data from a table into  a qvd it will override the existing information.

[#5]

Hi,

If you want to drop qvd which store table you can use

Drop table Qvd_tablename;( which table qvd creates)

or else if you want to delete the qvd from specified path use this

Execute cmd.exe /c del C:/file.qvd;

delete qvd's from folder by scirpt

[#6]

Hi All,

Thanks for your help.

I am trying to exetute the following command from my script but not able to delete the below qvd file.

Execute cmd.exe /c del D:\Abdul Kaleem\Qlikview testing\qvd\test_load.qvd

let me know if any changes required in the command.

Thanks!

[michael_anthony]

Try Execute cmd.exe /c del "D:\Abdul Kaleem\Qlikview testing\qvd\test_load.qvd";

Need quotation marks around the file name or else the spaces confuse cmd.exe statement.

[#8]

Hello Michael,

still not able to delete the file.

[michael_anthony]

What happens when you run the script?

[jagan]

Hi,

Generally in Qlikview QVDs are not deleted, everytime we will replace the existing QVDs not sure why you are trying to delete the QVD from Qlikview.

This is not a good practice, instead you can create a windows job to do this periodically.

Hope this helps you.

Regards,

Jagan.