Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
gidon500
Contributor II

filter items from a table

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

Tags (1)
1 Solution

Accepted Solutions

Re: filter items from a table

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


talk is cheap, supply exceeds demand
4 Replies

Re: filter items from a table

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.


talk is cheap, supply exceeds demand
gidon500
Contributor II

Re: filter items from a table

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

Re: filter items from a table

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


talk is cheap, supply exceeds demand
gidon500
Contributor II

Re: filter items from a table

Hi

I used the outer join

it helps thanks

gidon

Community Browser