topic Re: Filter values in List Box in QlikView

Filter values in List Box

Sun, 06 Sep 2015 10:09:36 GMT

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

Re: Filter values in List Box

Anonymous — Sun, 06 Sep 2015 10:17:06 GMT

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)

Re: Filter values in List Box

MarcoWedel — Sun, 06 Sep 2015 10:57:21 GMT

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