Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
cbaqirdhds
Valued Contributor

Suppress Blank Values in List Box

How can I suppress blank values in a list box?

Tags (3)
1 Solution

Accepted Solutions
srikanthsri1
Valued Contributor

Re: Suppress Blank Values in List Box

use expression in list box and use this expression

if (field <> '',field)

hope it helps

Raj

3 Replies
srikanthsri1
Valued Contributor

Re: Suppress Blank Values in List Box

use expression in list box and use this expression

if (field <> '',field)

hope it helps

Raj

Re: Suppress Blank Values in List Box

If(Len(Trim(Field)),Field)

vardhancse
Valued Contributor III

Re: Suppress Blank Values in List Box

Yes, in list box take expression instead of direct field.

Expression:

if(field<> ' ',field)