topic Re: If statement with functions in QlikView

If statement with functions

zagzebski — Fri, 09 Jan 2015 20:14:45 GMT

Is it possible to use an if statement with functions in a script. Bascially I want a certain code in place based on an if statement. Is this possible? For example.

If( $(vMyVariable) = 1, Concatentate, NoConcatenate)

If($(vMyVariable) = 1, Drop Table Prod, '')

thanks in advance,

Steve

Re: If statement with functions

MK_QSL — Fri, 09 Jan 2015 20:24:44 GMT

something like

If $(vMyVariable) = 1 THEN

T1:

Load * From Table1;

Concatenate

Load * From Table2;

ElseIf

T1:

Load * From Table1

NoConcatenate

T2:

Load * From Table2;

Else

EndIF

If $(vMyVariable) = 1 Then

Drop Table TableName;

Else

EndIF

Re: If statement with functions

nagaiank — Fri, 09 Jan 2015 20:27:37 GMT

You may define a variable using if() and use that variable in the script. In some cases, you may use If .. Then .. EndIf

Examples 1

Let vMyConcatenate = if($(MyVariable)=1,'Concatenate','Noconcatenate');

$(vMyCocatenate) LOAD ...

Example 2

If $(vMyVariable)=1 Then

Drop Table Prod;

EndIf

Re: If statement with functions

its_anandrjs — Fri, 09 Jan 2015 20:29:40 GMT

Hi,

Yes you can do this in load script by use of if statements and the

1. For first see this example.

Ex:-

T1:

LOAD * Inline
[
ColA,ColB
A,1
B,2
C,3
];

LET vMyVariable = 1;

If $(vMyVariable) = 1 then

Concatenate
T2:
LOAD * Inline
[
ColA,ColB
1,ab
2,bc
3,cd
4,de
];

ELSEIF $(vMyVariable) <> 1 then

NoConcatenate

T2:
LOAD * Inline
[
ColA,ColB
1,ab
2,bc
3,cd
4,de
];

ENDIF

2. And for Second try some thing this ways

If $(vMyVariable) = 1 then

DROP Table T1;

Regards

Anand

Re: If statement with functions

rwunderlich — Fri, 09 Jan 2015 20:32:21 GMT

Yes, you can do what you are after but in a slightly different form. You need to assign the script test to a variable and then use the variable on a script line by itself. For example:

LET vConcat = if(NoOfRows('mytab')>0, 'CONCATNATE (mytab)', 'mytab:');

$(vConcat)

LOAD X,Y...

For your DROP TABLE example:

LET vDrop = If($(vMyVariable) = 1, 'Drop Table Prod;', '');

$(vDrop)

Note you can also do the DROP TABLE like

IF '$(vMyVariable)' = 1 THEN

DROP TABLE Prod;

ENDIF

WHEN '$(vMyVariable)' = 1 DROP TABLE Prod;

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: If statement with functions

zagzebski — Fri, 09 Jan 2015 20:52:37 GMT

Rob so I did something like this:

Let vMyConcat = If($(vTest), Concatenate, NoConcatenate)

but getting a "Script Line Error" memory

Re: If statement with functions

its_anandrjs — Fri, 09 Jan 2015 21:03:34 GMT

Hi,

Then try this way

T1:
LOAD * Inline [
Field1,Field2
A,1
B,2
C,3 ];

LET vTest = 1;
Let vMyConcat = If($(vTest)=1, 'Concatenate T1', 'NoConcatenate T1');

$(vMyConcat):
LOAD * Inline [
Field1,Field2
B,23
C,45
D,24
E,66 ];

Regards

Anand

Re: If statement with functions

zagzebski — Fri, 09 Jan 2015 21:07:51 GMT

So I got past the variable but I am getting the error "Table not Found" when I run this:

Let vMyConcatenate = if($(e)=1,'Concatenate','Noconcatenate');

For e = 1 to 2
ProdTest:
$(vMyConcatenate)
Load *
Resident Prod$(e);
Drop table Prod$(e);
next e

Re: If statement with functions

rwunderlich — Fri, 09 Jan 2015 23:57:53 GMT

I would think the Let should be in the loop and you have the concatenate logic reversed. Try like this

For e = 1 to 2

Let vMyConcatenate = if($(e)=1,'NoConcatenate','concatenate (ProdTest)');
ProdTest:
$(vMyConcatenate)
Load *
Resident Prod$(e);
Drop table Prod$(e);
next e

Here's a way you can skip the entire issue of having to set the Concatenate/NoConcatenate

For e = 1 to 2

ProdTest:
Load *, 1 dummyField
Resident Prod$(e);
Drop table Prod$(e);
next e

DROP FIELD dummyField;

Re: If statement with functions

zagzebski — Sat, 10 Jan 2015 16:16:29 GMT

Thanks Rob!