Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

janardhan
Contributor

Need to show NULL Values Also

Hi Friends,

I need to show Null values also in Filter Pane Object. I think Filter Pane object suppresses the Null Values. How to achieve this.

Thanks in Advance

Janardhan

14 Replies
sunilkumarqv
Valued Contributor II

Re: Need to show NULL Values Also

try this buddy ..

use as expression field in filter pane

If(isnull(Field),Field,Field)

janardhan
Contributor

Re: Need to show NULL Values Also

Hi Sunil ,

I tried but no luck

rnt
Valued Contributor

Re: Need to show NULL Values Also

As you mention, NULL values are not represented in the filter pane.

There are different options, for example to convert NULLs to a value that can be represented. This is done in the load script, using the NullAsValue statement:

http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/ScriptRegularStatem...

There's more information in the help about null handling options:

http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/null-value-handling...

MVP
MVP

Re: Need to show NULL Values Also

Hi Janardhan,

You need to handle this in script section like below

LOAD

Alt(Field1, 'NULL') AS Field1,

'

'

'

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

janardhan
Contributor

Re: Need to show NULL Values Also

Hi Ralf ,

Thanks for giving hint , I tried to use SET NULLDISPLAY='NULL';, its working , but i need to display all duplicate values in filter object

janardhan
Contributor

Re: Need to show NULL Values Also

Hi Jagan,

Thanks for your reply , i tried to use Alt(Field1, 'NULL') AS Field1, but i am getting only one value as NULL

MVP
MVP

Re: Need to show NULL Values Also

Hi,

Try like this

If(Len(Trim(FieldName)) = 0, 'NULL', FieldName) AS FieldName

Hope this helps you.

Regards,

Jagan.

janardhan
Contributor

Re: Need to show NULL Values Also

Hi Jagan,

I tried what u mentioned above , but i didnt get. Actually i got the solution by using SET NULLDISPLAY='NULL';.

Now i need to show duplicate values means how many times the NULL value repeats that i need to show in the filter object , not count. Filter object is showing only distinct values. I think u understand my requirement.

Any idea

antoniotiman
Honored Contributor III

Re: Need to show NULL Values Also

Hi,

if You want distinct NULL values, You can try

Alt(YourField,'NULL'&RecNo())       // or If(Len(Trim(.........

Regards,

Antonio