topic Re: Change List Box to show blank fields in QlikView

Change List Box to show blank fields

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Change List Box to show blank fields

arvind_patil — Tue, 25 Jul 2017 11:48:29 GMT

Hi Leo,

You Need To calculate at Script level As Below:

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

Thanks,

Arvind Patil

Re: Change List Box to show blank fields

Tue, 25 Jul 2017 11:58:19 GMT

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.

Re: Change List Box to show blank fields

neha_shirsath — Tue, 25 Jul 2017 12:01:03 GMT

Write below logic in script-

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

Re: Change List Box to show blank fields

arvind_patil — Tue, 25 Jul 2017 12:03:58 GMT

Re: Change List Box to show blank fields

Nagaraju_KCS — Tue, 25 Jul 2017 12:04:28 GMT

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

Re: Change List Box to show blank fields

arvind_patil — Tue, 25 Jul 2017 12:05:15 GMT

Hi Leo,

Kindly give sample code where you apply this condition

Thanks,

Arvind Patil

Re: Change List Box to show blank fields

Kushal_Chawda — Tue, 25 Jul 2017 12:06:57 GMT

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)