Filter values in List Box

[#1]

Hello,

I guess there is a simple solution for this need but I am knew to Qlik.

1.I have a list box in which I wish to present only few values (Like X, Y, Z) from the total Field's list.

(Like 'CompanyA', 'CompanyD'  and 'CompanyR' from the Company list).

I have tried to select <Expression> in General > Field  and in the expression to insert something like

sum ({<Company={'CompanyA', 'CompanyD' ,'CompanyR'}>}Company

But I guess SUM is not the relevant expression.

2. I have the same issue in a Chart table (Maybe I should use a different object?)  in which I want to show only a single property of a container.

The expressions are Container Name, Container Property and ContainerPropertyValue  and I wish to show only the Container Property=Date1 and the relevant date in the ContainerPropertyValue

Thank you,

Nir GL

[Anonymous · Accepted solution]

hi nir,

try:

Goto ListBox Properties -> "General Tab", you can set a "Expression" instead of a Fieldname. Then, in that expression, add any conditions you want to. This <Expression> option should be at the bottom of your fieldnames list.

Expression : =if(Company= { 'CompanyA', 'CompanyD' ,'CompanyR' },Company)

[MarcoWedel]

if(Match(Company, 'CompanyA', 'CompanyD' ,'CompanyR' ),Company)