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?
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')))
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)))
pick(match(L_Point, '3',' '6', '9'),
'Late stage', 'Mid stage', 'Early stage')