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

[#1]

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

May be someone can help me please?

Thanks,

Danny H

[CELAMBARASAN]

Hi

     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]

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.