topic remove unwanted character from list box in QlikView

remove unwanted character from list box

renjithpl — Wed, 29 Sep 2010 08:58:37 GMT

Hi All,

Here follows my coding to get day format like this : 12-Tue-Oct 2010

Day([Date Coded])&'-'&weekDay([Date Coded])&'-'&MonthName([Date Coded]) as Day,

I am showing day field in a list box.

but i am getting some null value

How can i eliminate it.?

Thanks in advance

Wed, 29 Sep 2010 09:06:23 GMT

Check first of your Date Coded field has a value!

IF(NOT ISNULL([Date Coded]),
Day([Date Coded])&'-'&weekDay([Date Coded])&'-'&MonthName([Date Coded]),
NULL()) as Day

renjithpl — Wed, 29 Sep 2010 10:39:25 GMT

Thanks Sander, its eliminated now.