Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Selecting Null values in a Filter

Hi All,

How to get null option get populated in the filter as 'N'

TIA

9 Replies
Highlighted
Contributor III
Contributor III

Re: Selecting Null values in a Filter

digvijay‌ Can you please help me

Highlighted
MVP
MVP

Re: Selecting Null values in a Filter

You can create something for all null values like below.

Say you have Category null.. then you can write something in your script..

IF(IsNull(Category) or Len(Trim(Category))=0,'N',Category) as Category

So now all Null Category will be replaced by 'N', which you can select at front end list box.

Highlighted
Master III
Master III

Re: Selecting Null values in a Filter

Highlighted
Contributor III
Contributor III

Re: Selecting Null values in a Filter

Hi digvijay

Can you please send me the syntax to populate the null option

Thank you

Highlighted
Contributor III
Contributor III

Re: Selecting Null values in a Filter

Hi,

If I use this expression im getting  only option 'N' there's no 'Y

Thank you.

Highlighted
Master III
Master III

Re: Selecting Null values in a Filter

NullAsValue Field1, Field2;

set NullValue='<NULL>';

Highlighted
Creator II
Creator II

Re: Selecting Null values in a Filter

Hi Raman,

In the filter pane we cant see the Null values. If you have taken the field in table you can able to see the Null values present in your field.

Suppose if your Value field contains Null Values.

Image.png

To convert Null(-) into 'N' . Need to use the below script before QVD. In my example I have considered '<NoData>'

you can replace with 'N'

Null script.png

after reloading the script, in the value field wherever we have Null(-) those will be converted to <NoData>.

If you have taken value field in the filter pane also you can find N in place of Null(-) and remaining records as it is.

NODATA.png

Hope it helps


Highlighted
Specialist III
Specialist III

Re: Selecting Null values in a Filter

I think thats what manish suggested, if the value in the field is null or empty it will be replaced by 'N' or if the value is not null then the original value is placed in the field.

Are you getting only 'N' values ?

Highlighted
Contributor II
Contributor II

Re: Selecting Null values in a Filter

I just used this. It worked. Thank you very much