2 Replies Latest reply: Jan 9, 2010 4:28 AM by Sajid Mahmood RSS

    Linktables Script in Qlikview 9

    Sajid Mahmood

      I am totally new to qlikview environment and would appreciate your support to solve my problem. I have two tables as follows, one for actual sales data and other for budget data. How can I link them (the script part) to get my analysis by month, client, product, time, city etc. I don't have any primary key / unique key for these tables. These tables are residing in Oracle Database and I will use OLE ODBC connection to retrieve the data. Please advise the steps line by line to create the script in Qlikview.

       

       

      ACTUAL SALES DATA TABLE

      CLIENT

      CITY

      CNY

      PERIOD

      MTH

      QTR

      YEAR

      PLINE

      SUBCATG

      PSUB

      VUOM

      VOLUME

      QTY

      SALE

      ASP

      UOMTO

      VOLUMTO

      PGROUP1

      GKWIRE

      RAK

      USA

      30/04/2009

      4

      2

      2010

      O2

      O2

      O2GS

      M3

      156

      26

      520

      3.33

      M3

      156

      PRDGAS

      MABANIST

      RAK

      USA

      30/04/2009

      4

      2

      2010

      AC

      ACEY

      ACEY

      KG

      132

      24

      2856

      21.6

      KG

      132

      PRDGAS

      KIRBY

      RAK

      BRAZ

      30/04/2009

      4

      2

      2010

      O2

      O2RK

      O2GS

      M3

      1020

      4

      2091

      2.05

      M3

      1020

      PRDGAS

      FORMOIND

      RAK

      BRAZ

      30/04/2009

      4

      2

      2010

      AC

      ACEY

      ACEY

      KG

      16.5

      3

      465

      28.2

      KG

      16.5

      PRDGAS

       

       

      BUDGET SALES DATA TABLE

      YEAR

      MTH

      PERIOD

      CATEGORY

      CUSTCODE

      CUSTOMER

      CITY

      PRODUCT

      PRODCODE

      UOM

      QTY

      ASP

      REVENUE

      LOB

      CUSTSHORT

      PLINE

      PSUBCATG

      PSPEC

      2010

      MAR

      31/03/2010

      Metal

      CL00582

      Rasana Engineering Industry

      Shj/Aj/Uq

      D/A Rack (Kg)

      10377

      KG

      90.64

      26.7

      2416.46

      P

      RASANA

      AC

      ACEY

      ACRK

      2010

      APR

      30/04/2010

      Metal

      CL00380

      Haji Siddique Foundry

      Shj/Aj/Uq

      D/A Cyl (Kg)

      10044

      KG

      96.82

      25

      2420.5

      P

      HAJISF

      AC

      ACEY

      ACEY

      2010

      JUN

      30/06/2010

      Metal

      CL00790

      ATG Ltd. (Al Tuwairqi Group)

      Shj/Aj/Uq

      LOX (Nm3)

      10228

      M3

      2469.9

      0.99

      2445.24

      B

      ATG

      O2

      O2LQ

      O2L

      2010

      NOV

      30/11/2010

      Metal

      CL00732

      Zamil Steel

      Rak

      O2 Cyl (Nm3)

      10218

      M3

      978.5

      2.5

      2446.25

      P

      ZSIRAK

      O2

      O2GS

      O2

      2010

      NOV

      30/11/2010

      Metal

      CL00951

      Danem Engineering Works FZE - Hamriya

      Shj/Aj/Uq

      O2 Cyl (Nm3)

      10218

      M3

      669.5

      3.66

      2450.37

      P

      DANEMHAM

      O2

      O2GS

      O2

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Your quick reply will be highly appreciated

       

       

       

      Regards

      Sajid Mahmood