Adding null number into a field

[hanschucrutes]

Hello everyone, I'm trying to create a table where there are some expected null values, but I wanted to add these null values to the CR - Credit Risk field. I tried with the formula '=if(IsNull([x]), 'b', [x])' and a few other options but didn't succeed. Can someone help me?

[Anil_Babu_Samineni · Accepted solution]

@hanschucrutes I guess the null may not be real null, Anyway I can think like this for the field with calculated dimension.

If([Obligor Coding]='CF-Contract Frustration', 'CF-Contract Frustration', 'CR-Credit Risk')

[J_Venkateswara_Rao]

if your field consist only two values, then you can use above suggested solution by Anil. otherwise,

=if(IsNull([Obligor Coding]) or len([Obligor Coding])<=0 or ,len([Obligor Coding])='-', 'CR - Credit Risk', [Obligor Coding])

[rwunderlich]

How about:

Aggr(Coalesce([Obligor Coding], 'CR - Credit Risk'), [Obligor Coding])

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[qv_testing]

Try this

=if(LEN(TRIM([Obligor Coding]))=0, 'CR - Credit Risk', [Obligor Coding])