Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
avinashelite

Hi Bhawna,

try like this:

if(len(filedname)>0, filedname)

or

if(isnull(filedname)=0,fildname)

View solution in original post

7 Replies
MayilVahanan

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
Please close the thread by marking correct answer & give likes if you like the post.
sushil353
Master II
Master II

Hi,

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

HTH

Sushil

Not applicable
Author

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

avinashelite

Hi Bhawna,

try like this:

if(len(filedname)>0, filedname)

or

if(isnull(filedname)=0,fildname)

tresesco
MVP
MVP

Try expression like:

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

qv_jagan
Partner - Creator
Partner - Creator

Hi Bhawna,

Please attach the app in the discussion.

Thanks,

Jagan. V

Not applicable
Author

Thank you everyone....