topic Re: How to write if statement in Qlikview in QlikView

How to write if statement in Qlikview

Tue, 30 Jul 2013 15:35:43 GMT

How to write following code in Qlikview

IF Date(Today()) = YearStart(Today()

Delete all qvds where qnd name contains Year(Today())-3

Else

Don't do anything

EndIF

brunomarques — Tue, 30 Jul 2013 15:44:21 GMT

Have you tried something like this?

IF Date(Today()) = YearStart(Today()) Then

Let vYear = Year(Today()) - 3;

Let cmd = 'DEL *' & $(vYear) & '*.qvd';

execute cmd.exe /c $(cmd)

EndIf

Tue, 30 Jul 2013 15:51:36 GMT

Wher i can give the qvd path if I want to delete from specific folder only like D:\Qlikview\Qvds

Anonymous — Tue, 30 Jul 2013 16:05:26 GMT

execute cmd /c del "YourPath\YourFile(s)*.qvd";

shree909 — Tue, 30 Jul 2013 16:08:39 GMT

Hi , Try this

Add a variabel

Set vSourcedir='D:\Qlikview\Qvds\';

Let vYear = Year(Today()) - 3;

Let cmd = '*' & $(vYear) & '*.qvd';

execute cmd.exe /c DEL '$(vSourcedir) $(cmd)'

Tue, 30 Jul 2013 17:04:34 GMT

This created below execute statement and not deletiong files from location

execute

cmd.exe /c DEL 'D:\QlikView\Test\ *2010*.qvd'

Tue, 30 Jul 2013 17:16:16 GMT

It's done with following code:

IF Date(Today()) <> YearStart(Today()) Then

Let QvdPath = 'D:\QlikView\Test\';
Let vYear = Year(Today()) - 3;

Let cmd = '*'&$(vYear)&'*.qvd';
execute cmd.exe /c DEL $(QvdPath)$(cmd);
EndIf