topic Re: Keep related problem in QlikView

Keep related problem

Anonymous — Fri, 28 Feb 2014 09:12:28 GMT

Hi Everyone,

Here i'm facing problem . Actually i want to use keep in between two table . Requirement is user wise amount, qty and tax .

Please anyone help me ..

Thanks

Master:

LOAD USER_ID,

USERNAME,

DealerCode,

DealerName,

State,

City,

Region,

DealerType

FROM

MasterTable.xlsx

(ooxml, embedded labels, table is master);

Transaction:

LOAD USER_ID,

DealerCode,

DATE,

Amount,

Quantity,

DealerType,

Tax

FROM

Tab1.qvd

(qvd);

Re: Keep related problem

er_mohit — Fri, 28 Feb 2014 09:16:56 GMT

Try this

Master:

LOAD USER_ID &'|'&DealerCode&'|'&DealerType as Keylink,

USER_ID,

USERNAME,

DealerCode,

DealerName,

State,

City,

Region,

DealerType

FROM

MasterTable.xlsx

(ooxml, embedded labels, table is master);

Transaction:

LOAD USER_ID &'|'& DealerCode&'|'&DealerType as Keylink,

DATE,

Amount,

Quantity,

// DealerType, //comment it

Tax

FROM

Tab1.qvd

(qvd);

Re: Keep related problem

Fri, 28 Feb 2014 09:27:47 GMT

try this

Master:

LOAD

USER_ID & DealerCode as key,

USER_ID,

USERNAME,

DealerCode,

DealerName,

State,

City,

Region,

DealerType

FROM

MasterTable.xlsx

(ooxml, embedded labels, table is master);

left keep

Transaction:

LOAD

USER_ID & DealerCode as key,

USER_ID,

DealerCode,

DATE,

Amount,

Quantity,

DealerType,

Tax

FROM

Tab1.qvd

(qvd);

Re: Keep related problem

Anonymous — Fri, 28 Feb 2014 09:47:36 GMT

Hi Vishwaranjan,

Thanks for the reply, but still the synthetic key is generating. Actually here we don't use the join as the requirement.

Re: Keep related problem

kumarnatarajan — Fri, 28 Feb 2014 10:08:00 GMT

Hi,

Remove folloing fiels in Transaction table.

DealerCode,

DealerType

Keep Link field in trasaction look like mohit

Re: Keep related problem

Anonymous — Fri, 28 Feb 2014 11:57:34 GMT

Hi Niranjan,

Thanks for the reply. I have fixed the problem actually here there is no need of join or keep .

simply make combination of userid&dealercode as key in both table. Then on the basis of key both table would be connect in master table comment the userid and dealercode and in transaction table comment the dealertype.

Now both table would be connect and there is no synthetic key will generate.

Thanks