topic Re: filter items from a table in QlikView

filter items from a table

gidon500 — Thu, 03 Jan 2013 18:02:37 GMT

Hello

I need your help if possible to filter items from a table

I have 2 tables ( enclosed )

first is ITEMS where the is items , qty , price - SHEET ITEMS

second file listitems contain the parts that I need to filter - sheet list

the problem is that i get only the first few characters from the item

like 12* or 17* as shown in the file listitems

I need to create a table that will contain the line from the items table

where the items starts as shown in the listitems

the result should look like as shown

in file ITEMS sheet result

thanks for your help

gidon

Gysbert_Wassenaar — Thu, 03 Jan 2013 18:22:08 GMT

Like this:

T1:

LOAD Item,

qty,

price

FROM

ITEMS.xlsx

(ooxml, embedded labels, table is ITEMS)

where WildMatch(Item,'21*','17-*');

Your 17* match isn't correct since that will also find 173-7952, which isn't in your RESULT table.

gidon500 — Thu, 03 Jan 2013 18:31:31 GMT

Hello

thanks for your fast respons

i cannot use this solution as the itemlist changes

from time to time and the list get bigger

is there other solution for such a request

gidon

Gysbert_Wassenaar — Thu, 03 Jan 2013 18:41:53 GMT

See this discussion. Maybe Qlikview Components can help you, if not try the outer join option.

gidon500 — Sat, 05 Jan 2013 16:09:37 GMT

I used the outer join

it helps thanks

gidon