Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
See this discussion. Maybe Qlikview Components can help you, if not try the outer join option.
(ooxml, embedded labels, table is ITEMS)
Your 17* match isn't correct since that will also find 173-7952, which isn't in your RESULT table.
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
I used the outer join
it helps thanks