topic Re: Conditional Statement for IsNull not taking else part in QlikView

Conditional Statement for IsNull not taking else part

karunaramteke — Sat, 16 Nov 2024 00:29:13 GMT

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 — Fri, 12 Jun 2020 18:36:20 GMT

can you share a sample data and the expected output ?

karunaramteke — Sat, 13 Jun 2020 10:34:43 GMT

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.