topic Re: Why in Qlikview Expression can't write if then else endif? in QlikView

Why in Qlikview Expression can't write if then else endif?

Mon, 26 Mar 2012 03:21:55 GMT

Why in Qlikview Expression can't write if then else endif?

May be someone can help me please?

Thanks,

Danny H

CELAMBARASAN — Mon, 26 Mar 2012 04:34:16 GMT

In qlikview expression you have to use

if(condition,then expression,else expression).

if then else endif is to use in the edit script and it cannot be used in expressions.

Celambarasan

jagan — Mon, 26 Mar 2012 04:49:08 GMT

Hi,

In Qlikview expressions you have different syntax for If Else statement, the syntax is

=If(Expression, TrueExpression, FalseExpression)

Ex: If(Year = 2012, Sum(Sales), Sum(Profit))

The If Then Else EndIf syntax is used in Scripting to transform the data.

Hope this helps you.

Regards,

Jagan.