Need to show NULL Values Also

[janardhan]

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

[sunilkumarqv]

try this buddy ..

use as expression field in filter pane

If(isnull(Field),Field,Field)

[janardhan]

Hi Sunil ,

I tried but no luck

[Ralf-Narfeldt]

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

[jagan]

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]

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]

Hi Jagan,

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

[jagan]

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.

[janardhan]

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]

Hi,

if You want distinct NULL values, You can try

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

Regards,

Antonio