topic Re: Query on FileSize in QlikView

Query on FileSize

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to check the size of the file, if it is greater than 100 MB then script should stop and if it is less than that limit than the other steps need to be trigger.

BELOW ERROR MESSAGE I AM GETTING:

********************************************

Script line error:

if (FileSize(C:\Users\Desktop\14th Apr 2017\Test14AprQVD.qvd)> 100000000))

*********************************************

My actual script is :

if (FileSize(C:\Users\ROKY\Desktop\6th Apr 2017\Main data Alliance\Alliance14AprQVD.qvd)> 100000000)

EXIT Script;

ENDIF

if (FileSize(C:\Users\ROKY\Desktop\6th Apr 2017\Main data Alliance\Alliance14AprQVD.qvd)< 100000000)

Do the rest of the step processing

Please help in this issue.

Thanks,

Rohit

Re: Query on FileSize

Anil_Babu_Samineni — Fri, 14 Apr 2017 15:03:10 GMT

If condition required two parameters like If(Sales >0, 1)

From your script, It showing one parameter called Filesize. What you want to do with this

Re: Query on FileSize

Anonymous — Fri, 14 Apr 2017 15:05:18 GMT

Try this

if (FileSize(C:\Users\ROKY\Desktop\6th Apr 2017\Main data Alliance\Alliance14AprQVD.qvd)> 100000000) then

EXIT Script;

ENDIF

Re: Query on FileSize

krishnacbe — Fri, 14 Apr 2017 15:07:18 GMT

Hi,

Try below expression

if (FileSize('C:\Users\Desktop\14th Apr 2017\Test14AprQVD.qvd')> 100000000))

Re: Query on FileSize

Peter_Cammaert — Fri, 14 Apr 2017 15:15:31 GMT

Indeed, the actual file name should be specified as a string, so put it between single quotes.