Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Null fields do not seem to be selectable. I have tried several ways to evaluate the null fields but it doesn't work.
the way I do it is by using count with aggr
if(aggr(alt(count(CredentialExpireDate),0),primarykeyfieldofothertable)=0,'Inactive','Active').
maybe there is a better way
Is there a reason this is a chart function and not done through the load editor->replace values? That's where I'd go first.
there is a difference between null and missing value, it could be that you are using a dimension for which CredentialExpireDate doesn't exist, this cannot be handled with isnull…are you using dimensions from two different data tables?
it could also be that your if else is reaching dead end, can you share your full condition?
Thank you for pointing that out about the null vs missing value. Would that affect the length evaluation as well?
Is there a way to evaluate fields with missing values?
the way I do it is by using count with aggr
if(aggr(alt(count(CredentialExpireDate),0),primarykeyfieldofothertable)=0,'Inactive','Active').
maybe there is a better way
Wow thank you! this works!
Can you tell me what is happening here? Is it checking the primary key of the table?
it is trying to count instances of your field by primary key(identified by grouping with your existing dimensions( of other table.
if it is 0 or null(in this case it returns null as you are using aggr) then no common instance exist
len and isnull wont work directly on the missing value