Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi, you can use a mapping table: https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFunction...
Applymap is not correcting seems the function is not applicable
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
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
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.
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.