To write IF statement in load script

[#1]

I try the IF statement

if ("L_Point"='3','Late stage')　and

if ("L_Point"='6','Mid stage')　and

if ("L_Point"='9','Early stage')

but it's not work?! why? what the correct IF statement?

[Vegar · Accepted solution]

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/ConditionalFunctions/if.htm

Try:

if ("L_Point"='3','Late stage',

   if ("L_Point"='6','Mid stage',　

      if ("L_Point"='9','Early stage')))

[Anonymous]

Try

if(L_Point='3','Late stage', if(L_Point='6','Mid stage', if(L_Point='9','Early stage')))

This doesn't dictate what to do if the L_Point isn't 3, 6 or 9 so I am assuming it can't be any other number. If it can you will want to add something to the expression for example:

if(L_Point='3','Late stage', if(L_Point='6','Mid stage', if(L_Point='9','Early stage', Null())))

or

if(L_Point='3','Late stage', if(L_Point='6','Mid stage', if(L_Point='9','Early stage', L_Point)))

[maxgro]

pick(match(L_Point,      '3',' '6', '9'),

                                   'Late stage', 'Mid stage', 'Early stage')