Delte QVD

[manoranjan_d]

Hi all,

I want to delete QVD based on the monthly run check

my scenario is to delete the qvd ex:

i am storing the qvd 

Store Table into  $(Path)Table_$(vToday).qvd; where 

Let vToday = Date(Today(1),'DD-MMM-YYYY');

Monthly base run this will be created now if the path have more than 4 qvd with name(able_$(vToday)) then it has to delete the qvd and store the latest qvd in the path

example:

apr run qvd will be created, may, june, july and so on, but coming to aug run this has to check the folder whether this qvd existing with count of 4  qvds and if so delete all the four qvd and store the latest qvd in the path.

how to achieve this in script

[pradosh_thakur]

Two approach i will suggest. 

1: Let's say you app is going to production this month then this month should be 1 , april should be 2 , may should be 3 and so on . Delete the qvds when month num is 5,9,13,17 etc.

try the below. https://community.qlik.com/t5/QlikView-App-Development/How-delete-the-qvd-file/td-p/451542

2: Else count the qvds in that folder if  =4 then delete , have a look at the threads to count the number of qvds

https://community.qlik.com/t5/QlikView-App-Development/counting-no-of-files-present-in-folder/m-p/61...

-Pradosh

[manoranjan_d]

How to execute the cmd in the qliksense below is thread is for qlikview and they did some user setting to execute, how achieve the same in the qliksense

[pradosh_thakur]

Check this out from the Qlik Help

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ScriptRegularStatem...