1 Reply Latest reply: Dec 31, 2014 7:46 AM by Anand Chouhan RSS

    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
      [C:\Qlikview\QLIKVIEW RAW QVDS\Qlikview Geneva EBU QVD\BILLSUMMARY.qvd]
      (
      qvd);

       


      2.

       

      LOAD

       

       

      ACCOUNT_NUM,
      CUSTOMER_REF
      FROM
      [C:\Qlikview\QLIKVIEW RAW QVDS\Qlikview Geneva EBU QVD\ACCOUNT.qvd]
      (
      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
      [C:\Qlikview\QLIKVIEW RAW QVDS\Qlikview Geneva EBU QVD\BILLPRODUCTCHARGE.qvd]
      (
      qvd);

       

       

       

      4.

        • Re: Hi..Kindly Suggest.
          Anand Chouhan

          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
          [C:\Qlikview\QLIKVIEW RAW QVDS\Qlikview Geneva EBU QVD\ACCOUNT.qvd]
          (
          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
          [C:\Qlikview\QLIKVIEW RAW QVDS\Qlikview Geneva EBU QVD\BILLSUMMARY.qvd]
          (
          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
          [C:\Qlikview\QLIKVIEW RAW QVDS\Qlikview Geneva EBU QVD\BILLPRODUCTCHARGE.qvd]
          (
          qvd);



          Hope this helps you

          Regards

          Anand