Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nawazuddin234
New Contributor III

Selecting Null values in a Filter

Hi All,

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

TIA

8 Replies
nawazuddin234
New Contributor III

Re: Selecting Null values in a Filter

digvijay‌ Can you please help me

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.

Digvijay_Singh
Honored Contributor III

Re: Selecting Null values in a Filter

nawazuddin234
New 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

nawazuddin234
New 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.

Digvijay_Singh
Honored Contributor III

Re: Selecting Null values in a Filter

NullAsValue Field1, Field2;

set NullValue='<NULL>';

bhavvibudagam
Contributor 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


kkkumar82
Valued Contributor 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 ?

Community Browser