ISNULL() not working in listbox/multibox

[Anonymous]

Hi,

I have a chart where I am using a calculated dimension: : if(isnull(TargetFlag),' null','not null').

This is working fine in the chart as a column, however when i give the same condition in the listbox/multibox it doesn't show me the option 'null'.

Also clicking 'null' in the chart doesn't filter it. Not null works fine. Please advise.

[sunny_talwar]

Why don't you create this in the script?

LOAD if(isnull(TargetFlag),' null','not null') as NullFlag

[Anonymous]

NullFlag is not showing 'null'.

[sunny_talwar]

Are you doing any joins after your create this flag? If you are, I would suggest to create this flag at the very last resident load

[Anonymous]

I am doing an outer join.

[kaushiknsolanki]

You Can use the null variables like.

NullAsNull *fieldlist

Or NUllAsValue

Set NullValue = null();

Regards,

Kaushik Solanki

[sunny_talwar]

Create this flag in a resident load

Table1:

LOAD ...

Join (Table1)

LOAD ...

FinalTable:

LOAD *,

          YourFlagExpression

Resident Table1;

Drop Table Table1;

[sunny_talwar]

I don't think that will work if this variable is declared before the join

[Anonymous]

I need to keep the two tables separate.

[sunny_talwar]

Not dropping Funnel table... it will still be there... Can you post your script as text instead of image?