topic Re: Avoid Overwrite of QVD in QlikView

Avoid Overwrite of QVD

Wed, 05 Dec 2012 08:29:40 GMT

Hey everyone,

im actualy working on a freezing app for manual data added by the marketing team. Everything works fine the qvw does what is suppose to do.

The only thing i need to consider now is that if a file exist i dont want it to be overwritten by the app. Any idea's?

p.s If someone tries to overwrite a file a popup error on the up would be something appreciated

Re: Avoid Overwrite of QVD

Wed, 05 Dec 2012 09:05:24 GMT

Hi,

U can write script like this.

Sub Checkfile(Filename,fileExist)

Let fileExist=0

for each file in fileList('$(Filename)')

fileExist=1

exit for

End Sub

Tbl1:

Load * form Sometable;

Let isYesorNo=0;

Call Checkfile('C:\\Tbl1.qvd',isYesorNo);

If(isYesorNo=0)

store Tbl1 into 'C:\\Tbl1.qvd"

end if

hope it helps u.

Regards,

Kabilan K.

Re: Avoid Overwrite of QVD

Wed, 05 Dec 2012 09:27:18 GMT

thnx for the anserw im gonna try to implement it and will let you know

Regards

Juan Pedro

Re: Avoid Overwrite of QVD

Wed, 05 Dec 2012 10:18:00 GMT

Hi,

Refer the script in this attachment.

And Run the Script through press Debug button for easy to analysis Script.

Regards,

Kabilan K.

Re: Avoid Overwrite of QVD

Wed, 05 Dec 2012 13:30:54 GMT

Is working more than fine thanks for the tip.

One more question is possible to costumize and force a script error adding an else here?

If(isYesorNo=0) then

store Tbl1 into D:\Tbl1.qvd;

ELSE

end if

Regards

Juan Pedro

Re: Avoid Overwrite of QVD

Wed, 05 Dec 2012 14:11:23 GMT

Looks like is not possible yet to costumize a script error message.

Thnks for your time

Regards

Juan Pedro