Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to eliminate the null values in the list box

Hi,

In a column I have null value and I have created a list box and I don't want to show the null.

I would like to display only values, can anybody adivse...

Regards

Chriss

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Listboxes never contain null values. Whatever you see are not null values. You can limit what's visible by using an expression: =if(MyField<>'somevalue', MyField). That will show all values of MyField except the value somevalue. If you have empty string values that you want to hide you can use =If(len(MyField),MyField).


talk is cheap, supply exceeds demand