Field creation issue in Qliksense

[sravanthi26]

As a part of developing code changes, I am facing  an issue while creating one field 

 

 Have look on images , I have added information in this. I need to create a new field POA Insert user. Those are map table names. There is chance one tb id have both users plant and lsp at that time needed  both . Some times we have only plan or lsp values present what ever  present that should be in output field. If both plant and lsp null then only unknow. How to write this logic

[sravanthi26]

Hello,

Any suggestions  please 

[marksouzacosta]

Hi @sravanthi26, 

I missed some parts of your question, but I think you can use a function like Coalesce:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFun...

coalesce(ApplyMap1(), ApplyMap2(), ApplyMap3(),'Unknow') as myfield

Regards,

Mark Costa