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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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];