topic Re: QVD Exists Check in QlikView

QVD Exists Check

naziralala — Wed, 30 Dec 2015 21:34:48 GMT

Hello All,

I am trying to check if the qvd exists, using the QVDCreateTime function.

I am facing an error- it executes with zero lines fetched....

My script is below:

SET vPathQVD ='\\fillup\Qlikview\'

SET vStartYear = Year(Today())-3;

SET vEndYear = Year(Today())+1;

SET vHIEndYear =Year(Today())+1 ;

SET vHDateYear = Year(Today())-3;

FOR vYearQVD = $(vStartYear) to $(vHIEndYear) step 1

LET vQVDfile = vPathQVD & 'Hotel Inv '& vYearQVD & '.QVD';

LET vListQVDExists = NOT isnull(QVDCreateTime('$(vQVDfile)'));

IF $(vListQVDExists) THEN

[Hotel Inv]:

LOAD *

FROM [$(vQVDfile)] (qvd)

WHERE [HDate] >= '$(vHDateYear)';//'2013';

ENDIF;

NEXT; //end of load loop

Thanks in advance...

Re: QVD Exists Check

sunny_talwar — Wed, 30 Dec 2015 21:37:08 GMT

Try this approach may be for checking:

SET vPathQVD ='\\fillup\Qlikview\'

SET vStartYear = Year(Today())-3;

SET vEndYear = Year(Today())+1;

SET vHIEndYear =Year(Today())+1 ;

SET vHDateYear = Year(Today())-3;

FOR vYearQVD = $(vStartYear) to $(vHIEndYear) step 1

LET vQVDfile = vPathQVD & 'Hotel Inv '& vYearQVD & '.QVD';

LET vListQVDExists = If(FileSize(vQVDfile) > 0, -1, 0);

IF $(vListQVDExists) then

Re: QVD Exists Check

swuehl — Wed, 30 Dec 2015 21:52:39 GMT

Try stepping through the code using Debug mode in script editor. Check that every variable is evaluated and set correctly to expected value.

I think you should use LET instead SET here:

SET vStartYear = Year(Today())-3;

SET vEndYear = Year(Today())+1;

SET vHIEndYear =Year(Today())+1 ;

SET vHDateYear = Year(Today())-3;

Re: QVD Exists Check

naziralala — Wed, 30 Dec 2015 21:56:09 GMT

No.. Same result...0 lines fetched...

Re: QVD Exists Check

naziralala — Wed, 30 Dec 2015 22:32:15 GMT

That was a good suggestion.

I found one of the variables not being assigned a value...

Thanks.

Re: QVD Exists Check

naziralala — Wed, 30 Dec 2015 22:33:00 GMT

It worked with the variable getting its value.

Thanks.

Re: QVD Exists Check

sunny_talwar — Wed, 30 Dec 2015 23:09:28 GMT

Awesome. I suggest marking Stefan's answer as correct and close the thread down.

Best,

Sunny