Expression to Replace

[Eduard23]

Hi Everyone,

Currently im working in a report and i need expression to use to get the expected result.

this is the table below and expected result

Inventory Status	Expected Result
1	UNRESTRICTED
6EXP	BLOCKED
6DMG	BLOCKED
6QRN	QUARANTINE

[rubenmarin]

Hi, you can use a mapping table: https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFunction...

[Eduard23]

Applymap is not correcting seems the function is not applicable

[rubenmarin]

Applymap is to use in the app, so your repot uses the table with the expect result column, instead of Inventory Status.

If you are not refering to this try giving more info about your question, like where are you using this data, or the current configuration

[Saurabh_K14999]

Hi,

Use the below expression

=if(WildMatch(InventoryStatus,'1'),'UNRESTRICTED',
if(WildMatch(InventoryStatus,'6EXP'),'BLOCKED',
if(WildMatch(InventoryStatus,'6DMG'),'BLOCKED',
if(WildMatch(InventoryStatus,'6QRN'),'QUARANTINE','-')))
)

Regards,

SK

[rubenmarin]

Hi, and what's not working with that expression?

maybe you need to add some * like if(WildMatch(InventoryStatus,'6EXP*'),'BLOCKED',

Edit: Sorry @Saurabh_K14999, I thought I was answering to the initial poster.

[Eduard23]

For this one already solve, i just use the if 

IF(INVENTORY_STATUS=1, 'UNRESTRICTED',IF(INVENTORY_STATUS='6DMG', 'BLOCKED',IF(INVENTORY_STATUS='6EXP', 'BLOCKED',IF(INVENTORY_STATUS='6QRN', 'QURANTINE', ''))))

thanks for the support really need to learn a lot.