Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

If else condition

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
1 Reply
risabhroy_03
Partner - Creator II
Partner - Creator II
Author

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];