How to create new distinct list of values from concatenated dimension values

[#1]

I have two columns in my table Product Name and Scope as shown below

Table Name: Product_Management

Product	Scope Group
Silver Line	T1, M1, C2
Gold Line	T1
Platinum	M1
Platinum Pro	C2, M3
Arc2	A, C, C2

I want a list box like the one below with distinct values from SCOPE Group Column

List Box: SCOPE

Scope
T1
M1
C2
M3
A
C

When the user selects a value from "Scope" list they should be able to filter records from Product_Management table where ever the scope is present.

Ex: If user selects "C2" from SCOPE list then the Product_Management table should display

Product	Scope Group
Silver Line	T1, M1, C2
Platinum Pro	C2, M3
Arc2	A, C, C2

*** The actual table has thousands of rows in it and more combination of codes. The example above is just a snippet of it. If any body could help me how this could be achieved in Qlikview it would be great. I use a personal edition and doing a POC to see if this tool is good for our business. The above scenario is one of the POC. Thanks in advance.

[swuehl]

Something like

PRODUCT:

LOAD Product,

          ScopeGroup,

          RecNo() as ProductID

FROM Product_Management;

SCOPE:

LOAD ProductID,

           SubField(ScopeGroup, ',') as Scope

RESIDENT PRODUCT;

[MarcoWedel · Accepted solution]

Hi,

some slight change that depending on the actual data might reduce the size of the scope table:

tabProd:
LOAD Product,
    [Scope Group],
    AutoNumber([Scope Group]) as %ScopGrpID
FROM [https://community.qlik.com/thread/200824] (html, codepage is 1252, embedded labels, table is @1);

tabScopeGrp:
LOAD Distinct
    %ScopGrpID,
    Trim(SubField([Scope Group],',')) as Scope
Resident tabProd;

hope this helps

regards

Marco

[jagan]

HI,

Try like this

PRODUCT:

LOAD Product,

ScopeGroup,

Trim(SubField(ScopeGroup, ',') )AS Scope

FROM DataSource;

Regards,

Jagan.

[#5]

Thank you very much.

[#6]

Thanks

[#7]

Thanks