NullAsValue in Qliksense

[Sai_Mohan]

Hi Team,

In a table, I have a column named as'Title'. In that Field, I have many values like ('Manager', 'engineer', 'support', 'others',       '-', 'Technical', 'Security', '-', 'Lead'). My work here is I have to show 'Others ' and ' - ' as 'NO TITLE' and remaining names should be displayed.

For example:

Title

Engineer

lead

-

Others

Manager

Support

-

In this Title field, I have to show it like:

Title

Engineer

lead

No Title

Manager

Support

No Title

Note: I am getting this values from SQL. In Qlik Report, It is not showing '-' value, unless I export it to excel. So, I used NullASValue In Load editor. It is not giving any error but its not working.

Please give some solution which i can write in my expression

I tried expression like this :(Nothing worked)

1. if(Title = 'Others', '-', 'No Title', Title)

2. if(IsNull(Title) OR Title = 'Others', 'No Title', Title)

3. If(Title ='Others' OR Title = '-' ,No Title', Title)

Thanks 

Sai 

[Gui_Approbato]

HI Sai,

Did you try creating a column in the script?

I would do:            if( IsNull(Title), 'NO TITLE', if( Title='Others', 'NO TITLE', Title)) as Title2;

[Sai_Mohan]

Thanks for replying @Gui_Approbato 

But its not working. '-' is not showing up under 'No Title'.

Any solutions? 

If I uncheck "Include null values ", then those values are gone, but I need that values under 'No Title'

Thanks In Advance 

[Gui_Approbato]

What if in the load editor you change the column to:

 if( Len( Trim(Title))=0 , 'NO TITLE',     if( Title='Others', 'NO TITLE', Title)   ) as Title;

[Sai_Mohan]

Hi @Gui_Approbato ,

Still I am not getting that😅

Thanks for the help! I really appreciate your work!