Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to implement this condition in Qlik sense
Inventory Type | Logic |
Inporcess Inhouse | if catg=4 |
Inprocess Subcontracting | if catg=6 |
if catg = '-', then check below condition | |
FG | if warehouse set = 100 or 900 |
FG ARE-1 | if Warehouse set = 700 |
WIP\Sub-assemblies | if warehouse set = 200 or 500 |
RM\BOP | if warehouse set = 300 |
BOP ARE-1 | if Warehouse set = 800 |
Job work | if warehouse set = 950 |
Consumable | if warehouse set = 400 |
I wrote this but I am only getting first two conditions and rest are coming as '-'
if(("T$CATG")=4,'Inprocess Inhouse'
,if(("T$CATG")=6,'Inprocess Subcontracting'
,if(("T$CATG")='-'
,if([Warehouse Set]=100 or [Warehouse Set]=900,'FG'
,if([Warehouse Set]=700,'FG ARE-1'
,if([Warehouse Set]=200 or [Warehouse Set]=500,'WIP\Sub-assemblies'
,if([Warehouse Set]=300,'RM\BOP'
,if([Warehouse Set]=800,'BOP ARE-1'
,if([Warehouse Set]=950,'Job work'
,if([Warehouse Set]=400,'Consumable')))))))))) as [Inventory Type];