topic Re: Filter in ListBox in QlikView

Filter in ListBox

bimala0507 — Tue, 18 Nov 2014 03:40:35 GMT

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

Re: Filter in ListBox

nagaiank — Tue, 18 Nov 2014 03:44:18 GMT

You may use the following expression for the list box:

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

Re: Filter in ListBox

Tue, 18 Nov 2014 04:28:08 GMT

try like this

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

Re: Filter in ListBox

JonnyPoole — Tue, 18 Nov 2014 04:44:26 GMT

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)

Re: Filter in ListBox

jsingh71 — Tue, 18 Nov 2014 05:09:37 GMT

See attachment.

Re: Filter in ListBox

ashfaq_haseeb — Tue, 18 Nov 2014 05:10:26 GMT

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

Re: Filter in ListBox

jagan — Tue, 18 Nov 2014 05:43:41 GMT

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.