Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)))
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.