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
