topic Re: Trying to Write IF statement in Qlik Learning Discussions

Trying to Write IF statement

Mon, 01 Dec 2014 09:57:35 GMT

Hi All,

I am new to Qlikview. I am using Qlikview Desktop.

I am trying to write an IF statement. When I wrote the IF Statement, Expression is OK. But when I am trying to use the same variable in the expression to represent in the Chart table, It is giving all "-" the stated marks but not the values. Can someone let me know How to use a variable in the table which is a IF statement.

Thanks,

Sukumar.

Re: Trying to Write IF statement

alexandros17 — Mon, 01 Dec 2014 10:03:53 GMT

Are you using SET to define the expression?

Could you share it with us?

Re: Trying to Write IF statement

Mon, 01 Dec 2014 10:31:08 GMT

Hello Alessandro,

Here is how I wrote the IF statement.

=If(Sum([Object1]) >= (Sum($(GAP))*-1),

If(Sum([Object1]) >= (Sum([SS]) - Sum([SH])),Sum([[Object1]]),

If((Sum($(GAP))*-1) >= (Sum([SS]) - Sum([SH])),(Sum($(GAP))*-1),

Sum([SS]) - Sum([SH]))))

Please correct me. and also I need to use this variable in another variable.

Thanks,

Krupa Sukumar B.

Re: Trying to Write IF statement

Mon, 01 Dec 2014 11:22:33 GMT

Hi Alessandro,

When I write the same IF statement in an expression it is working fine.

But when used as a variable, it is not working.

Re: Trying to Write IF statement

jpenuliar — Mon, 01 Dec 2014 11:36:43 GMT

Can you also post your Set analysis code.

And what is your current actual value of your variable?

Re: Trying to Write IF statement

Mon, 01 Dec 2014 12:41:10 GMT

Hello Jonathan,

I haven't written any set analysis Code as i am totally new to this Qlikview. Can you please suggest any document for reference to write this Set Analysis Code.

I have written only the above mentioned IF statement.

Thanks,

Sukumar.

Re: Trying to Write IF statement

jpenuliar — Mon, 01 Dec 2014 12:44:26 GMT

can you send your qv file to review?,