Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to implement this condition in Qlik sense
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];