Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Supress NullValue in List box

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    

1 Solution

Accepted Solutions
Highlighted

Hi Bhawna,

try like this:

if(len(filedname)>0, filedname)

or

if(isnull(filedname)=0,fildname)

View solution in original post

7 Replies
Highlighted

Hi

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 ;

Thanks & Regards,
Mayil Vahanan R
Highlighted
Master II
Master II

Hi,

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

HTH

Sushil

Highlighted
Not applicable

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

Highlighted

Hi Bhawna,

try like this:

if(len(filedname)>0, filedname)

or

if(isnull(filedname)=0,fildname)

View solution in original post

Highlighted
MVP
MVP

Try expression like:

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

Highlighted
Partner
Partner

Hi Bhawna,

Please attach the app in the discussion.

Thanks,

Jagan. V

Highlighted
Not applicable

Thank you everyone....