If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have struggle with this calculated field I need to make.
In first case i need to mark all rows that contains "TBC" in field Customer PO as "DUMMY-COMMITED"
In secon case i need to mar all rows that contains "DUMMY" as "DUMMY"
Rest should be marked as "COMMITED"
Is there any expression that should solve this?
l(If(WildMatch([Customer PO],'TBC'),'DUMMY-COMMITED',(IF(WildMatch([Customer Code],'DUMMY'),'DUMMY','COMMITED'))))
@MT4T As @BrunPierre mentioned you can just use his logic, or if you wanted to use wildmatch in your expression there is a slight change, please see as below:
View solution in original post
Provide any sample data to understand better
@MT4T Per your logic this simple statement in the script should work
IF([Customer PO]='TBC','DUMMY-COMMITED',IF([Customer Code]='DUMMY','DUMMY','COMMITED') AS [Field Name]
Thank you, save my day. The missing "*" was an issue.