Multiple possible values in if condition

[Qlik_dev999]

Hello,

I have this field based on anothe field : 

If( [Eligibility ]='A' and (IsNull([Dev]) and IsNull([Staging])),'Value1',

If([Eligibility ]='A' and (not IsNull(Production) or not IsNull([Staging])) ,'Value2',

If([Eligibility ]='B','Value3',

If([Eligibility ]='C','Value4',

If([Eligibility ]='D','Value5',


if(IsNull([Eligibility ]) or [Eligibility ]='NA' ,'Blanks',



[Eligibility ])))))) as New Field

The problem is for Value2 i have two conditions : 

first one : If([Eligibility ]='A' and (not IsNull(Production) or not IsNull([Staging]))

Second one : ([Eligibility ]='A' and ( IsNull(Production) and IsNull([Staging]) and IsNull([Dev])) and (WildMatch("Status",'In-Progress','Not Started','Pending'))

when i try to add them together i don't have a result i used and between the two expressions but it doesn't work

Any suggestions please ?

Thanks

@sunny_talwar 

[Qlik_dev999]

Hello everybody...

Any solutions ? 

Thanks

[Taoufiq_Zarra]

@Qlik_dev999  can you share a simple with the expected result ?

[Qlik_dev999]

Hello,

Thx for your answer

I explain to you...i have multiple condition and to calcul value 2 i need like this

Condition 1 +  condition 2 as value 2

If (condition 1 or condition 2 ) as value 2

Thx 

[Taoufiq_Zarra]

@Qlik_dev999  it will be simple with example :

If([Eligibility ]='A' and (not IsNull(Production) or not IsNull([Staging])),if(
    [Eligibility ]='A' and ( IsNull(Production) and IsNull([Staging]) and IsNull([Dev])) and 
    (WildMatch("Status",'In-Progress','Not Started','Pending')),'Value2')
)



If( [Eligibility ]='A' and (IsNull([Dev]) and IsNull([Staging])),'Value1',

If([Eligibility ]='A' and (not IsNull(Production) or not IsNull([Staging])),if(
    [Eligibility ]='A' and ( IsNull(Production) and IsNull([Staging]) and IsNull([Dev])) and 
    (WildMatch("Status",'In-Progress','Not Started','Pending')),'Value2'),

If([Eligibility ]='B','Value3',

If([Eligibility ]='C','Value4',

If([Eligibility ]='D','Value5',


if(IsNull([Eligibility ]) or [Eligibility ]='NA' ,'Blanks',



[Eligibility ])))))) as New Field