Hi..Kindly Suggest.

[#1]

Hi, I am new to Qlikview..

I have 5 QVDs with fields mentioned below:

1. BillSummary:

LOAD ACCOUNT_NUM,
INVOICE_NET_MNY,
INVOICE_TAX_MNY,
INVOICE_NUM,
ACTUAL_BILL_DTM
FROM

(qvd);

2.

LOAD

ACCOUNT_NUM,
CUSTOMER_REF
FROM

(qvd);

3.

Product_Id_Map:

LOAD ACCOUNT_NUM as ACC_NO_PrdId,
CUSTOMER_REF as Cusref,
PRODUCT_ID,
if(CHARGE_TYPE=1,CHARGE_COST_MNY/1000) as MRC,
if(CHARGE_TYPE=2,CHARGE_COST_MNY/1000) as NRC,
CHARGE_COST_MNY,
CHARGE_TYPE

FROM

(qvd);

4.

[its_anandrjs]

Hi,

Its better if you Map the second table and load as mapping table and in the third table do not rename

CUSTOMER_REF field and it will associate with the BillSummary table for more see the script below.

Or you can try with do not rename ACCOUNT_NUM field also instead of CUSTOMER_REF and you can use ACCOUNT_NUM for association

MapTab:
Mapping LOAD
ACCOUNT_NUM,
CUSTOMER_REF
FROM

(qvd);

BillSummary:
LOAD
ACCOUNT_NUM,
ApplyMap('MapTab',ACCOUNT_NUM,'Unknown') as CUSTOMER_REF,
INVOICE_NET_MNY,
INVOICE_TAX_MNY,
INVOICE_NUM,
ACTUAL_BILL_DTM
FROM

(qvd);


Product_Id_Map:
LOAD
ACCOUNT_NUM as ACC_NO_PrdId,

ACCOUNT_NUM,
CUSTOMER_REF as Ref,
PRODUCT_ID,
if(CHARGE_TYPE=1,CHARGE_COST_MNY/1000) as MRC,
if(CHARGE_TYPE=2,CHARGE_COST_MNY/1000) as NRC,
CHARGE_COST_MNY,
CHARGE_TYPE
FROM

(qvd);

Hope this helps you

Regards

Anand