topic Re: Supress NullValue in List box in QlikView

Supress NullValue in List box

Mon, 25 Aug 2014 05:46:38 GMT

Hi everyone,

I have an issue in my application. I have created a list Box for a Quarter. But it show an extra value Q,I dont understand why it is showing,I dont have any null date filed.So my question is,how to supress nullvalue in list box?

if any one have any idea please share your suggestion.

Thanks

Bhawna

Re: Supress NullValue in List box

MayilVahanan — Mon, 25 Aug 2014 05:51:44 GMT

Try like this

Properties -> Presentation tab-> Supress null values

Edit:

Sorry, I thought in chart..

Load *,

'Q' & ceil(month(Datefield) / 3)

from tablename where Len(Trim(Datefield)) > 0 ;

Re: Supress NullValue in List box

sushil353 — Mon, 25 Aug 2014 05:53:45 GMT

Hi,

You can use expression in listbox. to eliminate extra values.

HTH

Sushil

Re: Re: Supress NullValue in List box

Mon, 25 Aug 2014 05:53:47 GMT

But in list box there is no such option...

Re: Supress NullValue in List box

avinashelite — Mon, 25 Aug 2014 05:54:40 GMT

Hi Bhawna,

try like this:

if(len(filedname)>0, filedname)

if(isnull(filedname)=0,fildname)

Re: Supress NullValue in List box

tresB — Mon, 25 Aug 2014 05:55:17 GMT

Try expression like:

=If(Len(Trim(YourField))>0,Field)

Re: Supress NullValue in List box

qv_jagan — Mon, 25 Aug 2014 05:55:36 GMT

Hi Bhawna,

Please attach the app in the discussion.

Thanks,

Jagan. V

Re: Re: Supress NullValue in List box

Mon, 25 Aug 2014 05:58:32 GMT

Thank you everyone....