If statement scenario

[NewUser3]

hello everyone,

Scenario: if existing dimensional column is null then pick value from other given column.

other column comes from different table but connected to main table with primary key. 

mater dimension: =if(USE_BusnUnit,'-',USE_BusnUnit1)

however, with above expression, i am getting values from "USE_BusnUnit1" even if "USE_BusnUnit" is not null. I want to have values from "USE_BusnUnit" and then from "USE_BusnUnit1". 

please help with your valuable thoughts on how I can achieve it. Qlik Sense Enterprise on Windows 

[NewUser3 · Accepted solution]

just used Coalesce() and it worked..

[F_B]

Hi @NewUser3 , welcome to the Community!

Threre'a an error in your expression, try with this:

=if(USE_BusnUnit = '-',USE_BusnUnit1)

[sbaro_bd]

Hi @NewUser3 ,

If you found the solution, marked the post as resolved to help others users which we'll face to the same issue like you in the future 😊.

Regards.

[NewUser3]

Yes, just did. Thanks for telling, i did not know it

[NewUser3]

nope..it isn't work. Coalesce()  can even take multiple parameters..