topic function if() in QlikView

function if()

Thu, 16 Apr 2015 08:53:54 GMT

Hello everyone,

I Have a question about if's function: Can I use this function with a FTP in the condition? Because I want to know if my file exist in this FTP or if it doesn't exist pass to another FTP and can I put a LOAD in the "if". And I always have an error with my "if" with the sign after my condition in red.

for a = 1 to FieldValueCount('Code')

let vCountryCode = FieldValue('Code', $(a));

for m = 1 to FieldValueCount('Id');

let vUserId = FieldValue('Id', $(m));

let vPassword = FieldValue('Password', $(m));

If([ftp://$(vUserId):$(vPassword)@11.111.11.111/DV/AAA%20AAA%20AAA%20-%20$(vCountryCode)%20-%20AAA%20AAA%20AA.xlsx] <> 'Null' ,

YourTable:

LOAD * FROM [ftp://$(vUserId):$(vPassword)@10.198.32.118/DV/AAA%20AAA%20AAA%20-%20$(vCountryCode)%20-%20AAA%20AAA%20AA.xlsx.xlsx]

(txt, codepage is 1252, embedded labels, delimiter is ';', no quotes, table is Feuil1);

STORE CONVERT into TABLESv2/VVV.qvd(qvd);

NEXT, NEXT)

NEXT

I hope this is not too confuse.

Regards

Re: function if()

sebastianlettner — Thu, 16 Apr 2015 15:25:15 GMT

Hi,

try using FileSize()

for a = 1 to FieldValueCount('Code')

let vCountryCode = FieldValue('Code', $(a));

for m = 1 to FieldValueCount('Id');

let vUserId = FieldValue('Id', $(m));

let vPassword = FieldValue('Password', $(m));

if(FileSize([ftp://$(vUserId):$(vPassword)@11.111.11.111/DV/AAA%20AAA%20AAA%20-%20$(vCountryCode)%20-%20AAA%20AAA%20AA.xlsx] )<> Null()) then

YourTable:

LOAD * FROM [ftp://$(vUserId):$(vPassword)@10.198.32.118/DV/AAA%20AAA%20AAA%20-%20$(vCountryCode)%20-%20AAA%20AAA%20AA.xlsx.xlsx]

(txt, codepage is 1252, embedded labels, delimiter is ';', no quotes, table is Feuil1);

STORE CONVERT into TABLESv2/VVV.qvd(qvd);

endif

NEXT

Re: function if()

buzzy996 — Thu, 16 Apr 2015 15:28:49 GMT

try this way,

i don't think so qlikview can understand directly, u can create a varaible & paly with tht some how