topic Re: if - elseif construction in QlikView

if - elseif construction

Anonymous — Tue, 21 May 2013 08:00:58 GMT

Hi all,

I would like to use the following statement in my script, but it doesn't work:

"reisezeit" is a variable which can be 0 or 1.

if reisezeit = 1 then

sum(if(Reisezeit='Nein', Stunden) )as Stunden_Projekt;

elseif

reisezeit = 0

sum(Stunden) as Stunden_Projekt;

ELSE

sum(Stunden) as Stunden_Projekt;

end if

Does someone has an idea why?

Thank you for your help.

Re: if - elseif construction

Sokkorn — Tue, 21 May 2013 08:05:31 GMT

Hi robert2012,

Can you change if reisezeit to if $(reisezeit) then try again.

Regards,

Sokkorn

Re: if - elseif construction

sushil353 — Tue, 21 May 2013 08:10:11 GMT

try this:

if($(Reisezeit) = 1,sum(if($(Reisezeit)='Nein', Stunden,if($(Reisezeit) = 0,sum(Stunden))))) as Stunden_Projekt

HTTH

Sushil

Re: if - elseif construction

Anonymous — Tue, 21 May 2013 08:13:29 GMT

Hi,

thx, but there is still a mistake as QlikView says:

Error in expression:

')' expected

But I don't see where!

You?

Re: if - elseif construction

Anonymous — Tue, 21 May 2013 08:15:17 GMT

Hi Sokkorn,

thank you very much.

I changed the first and both, but it still doens't work.

It says: Syntax Fehler

You know why?

Re: if - elseif construction

anandathome — Tue, 21 May 2013 08:26:16 GMT

This should work ...

if(reisezeit=1,sum(if(Reisezeit='Nein',Stunden)),sum(Stunden)) as Stunden_Projekt;

Message was edited by: Anand K

Re: if - elseif construction

Anonymous — Tue, 21 May 2013 08:30:56 GMT

Hi,

thank u for your help:

I added $ for the variables:

if($(reisezeit) = 1,sum(if($(reisezeit)='Nein',Stunden)),sum(Stunden)) as Stunden_Projekt

Now QlikView says:

If takes 2-3 parameters

Re: if - elseif construction

Tue, 21 May 2013 08:32:10 GMT

Try this :

if ($(reisezeit) = 1,

    sum(if(Reisezeit='Nein', Stunden)),

    if($(reisezeit)=0,

       sum(Stunden),

       sum(Stunden)

       )

     ) as Stunden_Projekt ;

If your variable takes only values 1 or 0, you can also write this :

if ($(reisezeit) = 1,

    sum(if(Reisezeit='Nein', Stunden)),

    sum(Stunden)

    ) as Stunden_Projekt;

Re: if - elseif construction

Anonymous — Tue, 21 May 2013 08:40:36 GMT

Hi Marie-Sophie Blond,

Thank you!

But there is "Error in expression: If takes 2-3 parameters"

for both ideas.

What can I do?

Re: if - elseif construction

anandathome — Tue, 21 May 2013 08:43:00 GMT

Remove the '$' sign and it should work for you

Re: if - elseif construction

Anonymous — Tue, 21 May 2013 08:52:34 GMT

There is still a problem with "

If takes 2-3 parameters"

and if I put $ away QlikView doens't find the field as it is a varible ?!

Hope you know why and you can help me

Re: if - elseif construction

Tue, 21 May 2013 09:03:24 GMT

Hi Rob!

There are 2 kinds of "IF" keyword.

The 1st is when you use it in Data Loading, use this syntax:

IF (condition) THEN

{statement_if_true}

ELSE

{statement_if_false}

END IF

The 2nd if is available in the Expression dialog with syntax:

=IF(condition, statement_if_true, statement_if_false)

It think what you're looking for is in the expression, which is 2nd if.

Hope that helps

Re: if - elseif construction

Tue, 21 May 2013 09:03:56 GMT

If you use other fields in your load statement, you must have a Group By Clause in your script.

LOAD

dimension1,

If ($(reisezeit) = 1,

    sum(if(Reisezeit='Nein', Stunden)),

    sum(Stunden)

    ) as Stunden_Projekt

RESIDENT Data

GROUP BY dimension1 ;

I used dmension1 as example.

Re: if - elseif construction

Anonymous — Tue, 21 May 2013 09:10:32 GMT

I use like you wrote:

Projekte_Monat:

LOAD MAID_Z,

left (MAID_Z, 14) as MAID_gesamt_Z,

If ($(reisezeit) = 1,

sum(if(Reisezeit='Nein', Stunden)),

sum(Stunden)

) as Stunden_Projekt

Resident ControllerExport_tmp1

Group by MAID_Z;

But there is always:

Error in expression: If takes 2-3 parameters

Re: if - elseif construction

Anonymous — Tue, 21 May 2013 09:15:17 GMT

Hi Adrian,

thank you for your help: I'm looking for the Data Loading:

I changed to:

Projekte_Monat:

LOAD MAID_Z,

left (MAID_Z, 14) as MAID_gesamt_Z,

If $(reisezeit) = 1 then

sum(if(Reisezeit='Nein', Stunden)) as Stunden_Project;

else

sum(Stunden) as Stunden_Projekt;

ENDIF

Resident ControllerExport_tmp1

Group by MAID_Z;

But there is still a mistake with my syntax, I can't solve

Re: if - elseif construction

er_mohit — Tue, 21 May 2013 09:25:41 GMT

Write this within load statement where your field Stunden exists in table

load

if($(Reisezeit) = 1,sum(if($(Reisezeit)='Nein', Stunden)),

if($(Reisezeit) = 0,sum(Stunden))) as Stunden_Projekt

Re: if - elseif construction

kumarnatarajan — Tue, 21 May 2013 09:27:35 GMT

Hi,

try this one.

Projekte_Monat:

LOAD

MAID_Z,
left (MAID_Z, 14) as MAID_gesamt_Z,
If($(reisezeit)=1,if(Reisezeit='Nein', Sum(Stunden)),sum(Stunden)) as Stunden_Project
Resident ControllerExport_tmp1
Group by MAID_Z;

where you are decler this variable. send your full script. reisezeit variable value standard or random.

Re: if - elseif construction

Tue, 21 May 2013 09:31:02 GMT

It's strange because i use the exact script you wrote in a test application and it works. (I have created an inline table with the 3 fields Reisezeit, Stunden and MAID_Z).

These 3 fields exist in the table ControllerExport_tmp1 ?

Re: if - elseif construction

Anonymous — Tue, 21 May 2013 11:14:08 GMT

Hi I changed to:

if($(reisezeit) = 1,sum(if( Reisezeit ='Nein', Stunden))),

if($(reisezeit) = 0,sum(Stunden)) as Stunden_Projekt

This works, but the results are wrong!

If I compare to:

sum (Stunden) as Stunden_Projekt

there are different results => Do you have an explanation/idee?

Thank you!

Re: if - elseif construction

Anonymous — Tue, 21 May 2013 11:46:51 GMT

I just wrote

set reisezeit = 0; //at the beginning of the skript

But theere is invalid expression!

Is there a problem with the variable?