topic Re: Inculde function with If statement is it Possible ...? in QlikView

Inculde function with If statement is it Possible ...?

sgg_gaikwad — Fri, 29 May 2015 11:44:14 GMT

This script is not working......

Config:

LOAD

ScriptConfig

FROM Configurations.xls

(biff, embedded labels, table is ObjectConfig$);

let VRow = NoOfRows('Config');

let VInclude = FieldValue('ScriptConfig',$(VRow));

if $(VInclude) then

$(Include= File1.qvs)

ELSE

$(Include= File2.qvs)

EXIT Script;

end if

Re: Inculde function with If statement is it Possible ...?

swuehl — Fri, 29 May 2015 11:47:43 GMT

Could you post a sample Configuration.xls?

Re: Inculde function with If statement is it Possible ...?

danieloberbilli — Fri, 29 May 2015 11:52:14 GMT

did you try to run it with the 'exit script;' at the very end (so after 'end if')?

Re: Inculde function with If statement is it Possible ...?

sgg_gaikwad — Fri, 29 May 2015 11:52:31 GMT

that file is having YES value..

Means if I pass Yes value in the ScriptConfig Column then first Qvs should work other wise Else part should execute.

Re: Inculde function with If statement is it Possible ...?

Peter_Cammaert — Fri, 29 May 2015 11:53:57 GMT

Think about it: a table may contain 1000s of identical rows, but a field from that table will contain only one value: the one distinct value that appears in every row...

Your index of the last row is probably out of bounds by a large margin for field ScriptConfig. Does the Configurations.xls file contain empty values in column ScriptConfig?

Best,

Peter

Re: Inculde function with If statement is it Possible ...?

sgg_gaikwad — Fri, 29 May 2015 12:01:22 GMT

Hey Daniel Yes i have tried in that way Still not working ....?

Re: Inculde function with If statement is it Possible ...?

sgg_gaikwad — Fri, 29 May 2015 12:02:18 GMT

Hey Peter That Excel file is having One Column and One Row....

Re: Inculde function with If statement is it Possible ...?

maxgro — Fri, 29 May 2015 12:02:47 GMT

I tried this and it works (all files inthe same dir)

DIRECTORY;

Config:

LOAD ScriptConfig

FROM

Configurations.xls

(biff, embedded labels, table is ObjectConfig$);

let VRow = NoOfRows('Config');

let VInclude = FieldValue('ScriptConfig',$(VRow));

trace $(VInclude);

if len(trim('$(VInclude)'))>0 then

trace include file1;

$(Include=File1.qvs);

ELSE

trace include file2;

$(Include=File2.qvs);

EXIT Script;

end if;

Re: Inculde function with If statement is it Possible ...?

Peter_Cammaert — Fri, 29 May 2015 12:15:18 GMT

So you will encounter this problem as soon as you have two rows with a YES-value.

BTW the code in the middle:

if $(VInclude) then

with your data translates into

if YES then

which doesn't do much (except if you store -1 in variable YES), or into

if then

which is an illegal statement.

I think Massimo's IF statement will work more reliably.

Peter

Re: Inculde function with If statement is it Possible ...?

sgg_gaikwad — Fri, 29 May 2015 12:15:35 GMT

Hey hi Massimo,

The above script is worked for my First If statement but ELSE part is not working in the situation.

and one more question are you passing Text value in that column or Numeric one..?

Re: Inculde function with If statement is it Possible ...?

sgg_gaikwad — Fri, 29 May 2015 12:42:35 GMT

Hi Massimo,

Could you please try on this Application it's not yet working For Else condition...?

Means if i pass File2.qvs in .Xls it should go for Else part but not getting as expected..?

Regards,

Swapnil

Re: Inculde function with If statement is it Possible ...?

Fri, 29 May 2015 19:42:38 GMT

Hi Swapnil,

If you are passing the value of the file name already in the config file, then you do not need the if condition right.

Just use the value directly from the config file.

Config:

LOAD ScriptConfig

FROM

Configurations.xls

(biff, embedded labels, table is ObjectConfig$);

let VRow = NoOfRows('Config');

let VInclude = FieldValue('ScriptConfig',$(VRow));

trace>> Reading $(VInclude);

$(Include=$(VInclude))

maxgro has given on your requirement to check if there's a value or not in config file.

Re: Inculde function with If statement is it Possible ...?

maxgro — Fri, 29 May 2015 19:51:08 GMT

if len(trim('$(VInclude)'))>0 then

$(Include=$(VInclude));

// trace include file1;

// $(Include=File1.qvs);

//ELSE

// trace include file2;

// $(Include=File2.qvs);

// EXIT Script;

end if;