topic Re: Field creation issue in Qliksense in App Development

Field creation issue in Qliksense

sravanthi26 — Fri, 28 Mar 2025 15:21:03 GMT

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

Re: Field creation issue in Qliksense

sravanthi26 — Sat, 29 Mar 2025 19:53:03 GMT

Hello,

Any suggestions please

Re: Field creation issue in Qliksense

marksouzacosta — Sat, 29 Mar 2025 22:29:41 GMT

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/ConditionalFunctions/coalesce.htm

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

Regards,

Mark Costa