Change List Box to show blank fields

[#1]

I need a List Box to pull a list of dates from a column (LetterSentDate), however it's only pulling data where a date exists and isn't showing me all the blank fields.  My question is this: -

1. Is there a way for me to alter the properties of the List Box to show all values, even the blank fields?

2. Is there a way for me to alter the properties of the List Box to show ONLY the blank fields?

Again any help would be greatly appreciated.

[arvind_patil]

Hi Leo,

You Need To calculate at Script level As Below:

If(isnull (LetterSentDate),'NULL Value',LetterSentDate)  as [New LetterSentDate ]

Thanks,

Arvind Patil

[#3]

Thanks Arvind but that didn't work. 

I want to be able to show the Blank values in a list box as well as the fields that have a valid date. 

[neha_shirsath]

Write below logic in script-

If(isnull (LetterSentDate) or wildmatch(LetterSentDate,' ',''), 'Null values',LetterSentDate)  as [New LetterSentDate ]

[arvind_patil]

[qv_testing]

we can use NULLASVALUE function

NullAsValue *;

Set NullValue = '<NULL>';

this will work whole application... and you can specify single fields aslo...

See this link as well..

NULL handling in QlikView

[arvind_patil]

Hi Leo,

Kindly give sample code where you apply this condition

Thanks,

Arvind Patil

[Kushal_Chawda]

Either create the New field in script like below

if(len(trim(LetterSentDate))=0,'NA',LetterSentDate) as LetterSentDateAllValue

Now you can use LetterSentDateAllValue field in list box

or you can go to listbox expression in write below expression

aggr(if(len(trim(LetterSentDate))=0,'NA',LetterSentDate),LetterSentDate)