Filter in ListBox

[bimala0507]

Hi QlikView Experts:

Is there any way to filter out few values from the ListBox? Like e.g. If a field Product contain A, B,C & D and I want to display only A, B, is there a way to achieve it ?

Kind Regards,

Bimala

[nagaiank]

You may use the following expression for the list box:

If(Match(Product,'A','B').Product)

[#3]

try like this

sum({<only={'a','b'}>}sales)

[JonnyPoole]

instead of picking a field to display in the list box, scroll to the bottom of the list and select expression then you can use the sample mentioned above

ie: if(match(product,'A','B') , product)

[jsingh71]

See attachment.

[ashfaq_haseeb]

Hi,

Try this in your search string.

(A|B)

For separate field

Try this expression in your list box

=if(match(Name,'A','B'),Name)

Regards

ASHFAQ

[jagan]

Hi,

I think the better option is creating a new field in script itself, because by doing this the performance would be better and the logic is centralized, if there is a change you can just change in script instead of changing in all the list boxes.

LOAD

*,

If(Match(Name, 'A', 'B'), Name) AS NewFieldName

FROM DataSource;

Now in Dashboard you can directly use NewFieldName as filter.

Hope this helps you.

Regards,

jagan.