Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@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')
@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')
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])
How about:
Aggr(Coalesce([Obligor Coding], 'CR - Credit Risk'), [Obligor Coding])
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Try this
=if(LEN(TRIM([Obligor Coding]))=0, 'CR - Credit Risk', [Obligor Coding])