How to add second condition?

[jacek27031]

Hi Eveyone,

I have a code as below:

if(([BP2]='XXX'),
Sum(
RangeMax(
([# STI Plan] * (([Cprice] - ([XXX CDF] / 1.23 / [ER Plan] * (1 - T2_GP) * (1 - T1_GP))))),0)),
Sum(
RangeMax(
([# STI Plan] * (([Cprice] - ([CDF Calc] / 1.23 / [ER Plan] * (1 - T2_GP) * (1 - T1_GP))))),0)))

How to add second condition? Else_expr as you can see in both cases is the same.  

if(((Front='1'),
Sum(
RangeMax(
([# STI Plan] * (([Cprice] - ([SRP] / 1.23 / [ER Plan] * (1 - T2_GP) * (1 - T1_GP))))),0)),
Sum(
RangeMax(
([# STI Plan] * (([Cprice] - ([CDF Calc] / 1.23 / [ER Plan] * (1 - T2_GP) * (1 - T1_GP))))),0)))

[Mario_Petre]

The "else" condition can be another "if", since "elseif" is not supported directly: if - script and chart function ‒ Qlik Sense on Windows

The if function has three parameters, condition, then and else, which are all expressions. The two other ones, then and else, can be of any type.