topic NullAsValue in Qliksense in App Development

NullAsValue in Qliksense

Sai_Mohan — Thu, 02 Jul 2020 16:58:13 GMT

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

Re: NullAsValue in Qliksense

Gui_Approbato — Thu, 02 Jul 2020 17:03:32 GMT

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;

Re: NullAsValue in Qliksense

Sai_Mohan — Thu, 02 Jul 2020 17:44:37 GMT

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

Re: NullAsValue in Qliksense

Gui_Approbato — Thu, 02 Jul 2020 17:51:17 GMT

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;

Re: NullAsValue in Qliksense

Sai_Mohan — Thu, 02 Jul 2020 18:13:29 GMT

Hi @Gui_Approbato ,

Still I am not getting that😅

Thanks for the help! I really appreciate your work!