topic linking field via key in QlikView

linking field via key

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to link my derived field 'Sector', directly to the 'Product' field via a key field. So Sector field should be in a separate table.

My Requirement is, once the sector is created based on Category field, I want the Sector field to be linked DIRECLY to the correct Product values through a key field(and not via Category field)

Please help!

Re: linking field via key

shiveshsingh — Mon, 12 Mar 2018 12:43:15 GMT

Like this?

Sector:

LOAD if(WildMatch(Category,'B*'),'A1',

if(WildMatch(Category,'P*'),'A2')) as Sector

FROM

[.\many to manyData.xls]

(biff, embedded labels, table is Sheet1$);

Category_Temp:

load Category, Product, if(WildMatch(Category,'B*'),'A1',

if(WildMatch(Category,'P*'),'A2')) as Sector

FROM

[.\many to manyData.xls]

(biff, embedded labels, table is Sheet1$);