Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Hi..Kindly Suggest.

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.

1 Reply

Re: Hi..Kindly Suggest.

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

Community Browser