topic Re: Expression to Replace in Reporting Service & Alerting

Expression to Replace

Eduard23 — Thu, 10 Nov 2022 09:00:38 GMT

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

Re: Expression to Replace

rubenmarin — Thu, 10 Nov 2022 09:04:02 GMT

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

Re: Expression to Replace

Eduard23 — Thu, 10 Nov 2022 09:08:01 GMT

Applymap is not correcting seems the function is not applicable

Re: Expression to Replace

rubenmarin — Thu, 10 Nov 2022 09:25:41 GMT

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

Re: Expression to Replace

Saurabh_K14999 — Thu, 10 Nov 2022 09:27:42 GMT

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,

Re: Expression to Replace

rubenmarin — Thu, 10 Nov 2022 10:18:57 GMT

~~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.

Re: Expression to Replace

Eduard23 — Wed, 16 Nov 2022 07:27:59 GMT

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.