Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this buddy ..
use as expression field in filter pane
If(isnull(Field),Field,Field)
Hi Sunil ,
I tried but no luck
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:
There's more information in the help about null handling options:
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.
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
Hi Jagan,
Thanks for your reply , i tried to use Alt(Field1, 'NULL') AS Field1, but i am getting only one value as NULL
Hi,
Try like this
If(Len(Trim(FieldName)) = 0, 'NULL', FieldName) AS FieldName
Hope this helps you.
Regards,
Jagan.
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
Hi,
if You want distinct NULL values, You can try
Alt(YourField,'NULL'&RecNo()) // or If(Len(Trim(.........
Regards,
Antonio