topic Re: Multiple possible values in if condition in App Development

Multiple possible values in if condition

Qlik_dev999 — Tue, 02 Mar 2021 09:40:50 GMT

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

Re: Multiple possible values in if condition

Qlik_dev999 — Mon, 08 Mar 2021 09:51:41 GMT

Hello everybody...

Any solutions ?

Thanks

Re: Multiple possible values in if condition

Taoufiq_Zarra — Mon, 08 Mar 2021 09:53:26 GMT

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

Re: Multiple possible values in if condition

Qlik_dev999 — Mon, 08 Mar 2021 10:15:35 GMT

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

Re: Multiple possible values in if condition

Taoufiq_Zarra — Mon, 08 Mar 2021 10:32:51 GMT

@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