Conditional Statement for IsNull not taking else part

[karunaramteke]

Hi QlikExperts,

I have expression if(IsNull(Bank_Temp.Open_State_name),MC_State_Code,[ State Name]) in frontEnd.

Here in the above expression I get Null values for MC_State_Code , So it should pick values from  [ State Name] .

It is not picking values from [ State Name]. 

Please help.

Thanks in advance.

[Taoufiq_Zarra]

@karunaramteke 

can  you share a sample data and the expected output ?

[karunaramteke]

I cannot share the sample data.

I have all null values in open State name field. 

Some values are present in NC State code n some in state name. 

My expression is not taking the else part in it.