topic Re: Message pop up while running script in QlikView

Message pop up while running script

Fri, 26 Apr 2013 14:59:43 GMT

hi All,

while writting a if statement in script

if file = true then

load * from table

else

"File not saved on Drive"

end if

above gives an error .. please advise

thanks

Re: Message pop up while running script

Mon, 29 Apr 2013 08:21:42 GMT

hi All,

any luck on this request

Re: Message pop up while running script

jagan — Mon, 29 Apr 2013 14:30:57 GMT

Hi,

Try like this

SET vFileName='Refund.qvd';

// Set a variable indicating if the file exists or not. -1 is True, 0 is False

LET vFileExists = if(FileSize('$(vFileName)') > 0, -1, 0);

IF $(vFileExists) THEN

Data:

LOAD *

FROM $(vFileName);

ELSE

MsgBox("File Not exists.");

END IF;

Hope this helps you.

Regards,

Jagan.

Re: Message pop up while running script

Tue, 30 Apr 2013 07:02:30 GMT

hi jagan and all,

while using the above solution if the file is present on shared drive or not

vfileExists always give 0 value

please advise

thanks

Re: Message pop up while running script

jagan — Tue, 30 Apr 2013 08:38:56 GMT

Hi,

This script is working for me

SET vFileName='\\10.199.199.199\shared\Sales.qvd';

// Set a variable indicating if the file exists or not. -1 is True, 0 is False

LET vFileExists = if(FileSize('$(vFileName)') > 0, -1, 0);

IF $(vFileExists) THEN

Data:

LOAD *

FROM $(vFileName)(qvd);

ELSE

MsgBox('File Not exists.');

END IF;

Hope this helps you.

Regards,

Jagan.

Re: Message pop up while running script

Tue, 30 Apr 2013 08:41:35 GMT

i have xls file will that make a difference

set vFileName='\\........\sales.xls';

Re: Message pop up while running script

sujeetsingh — Tue, 30 Apr 2013 09:31:05 GMT

Jagan it worked but when i reload and file is not there then msg do not pop ups.

Re: Message pop up while running script

jagan — Tue, 30 Apr 2013 10:53:17 GMT

Hi,

Try this for excel file

SET vFileName='\\10.199.199.199\shared\QAReport.xlsx';

// Set a variable indicating if the file exists or not. -1 is True, 0 is False

LET vFileExists = if(FileSize('$(vFileName)') > 0, -1, 0);

IF $(vFileExists) THEN

Data:

LOAD *

FROM $(vFileName)(ooxml, no labels, table is Sheet1); // Sheet1 is the sheet name in your excel file

ELSE

MsgBox('File Not exists.');

END IF;

Hope this helps you.

Regards,

Jagan.

Re: Message pop up while running script

jagan — Tue, 30 Apr 2013 10:53:58 GMT

Hi,

I am getting the popup if the file is not available. Can you attach the script.

Regards,

Jagan.

Re: Message pop up while running script

Thu, 02 Apr 2015 22:39:45 GMT

Hi Jegan,

Thank for this ans. It helped me:

Hi,

Try this for excel file

SET vFileName='\\10.199.199.199\shared\QAReport.xlsx';

// Set a variable indicating if the file exists or not. -1 is True, 0 is False

LET vFileExists = if(FileSize('$(vFileName)') > 0, -1, 0);

IF $(vFileExists) THEN

Data:

LOAD *

FROM $(vFileName)(ooxml, no labels, table is Sheet1); // Sheet1 is the sheet name in your excel file

ELSE

MsgBox('File Not exists.');

END IF;