Hi I'm pretty new on qlikview, but I'm trying to code something pretty simple.
I'm trying to get a ranking on a join of 2 tables.
Temp: is the table that has the data
LFA1: is the table that has the other set of data
Tabla: is the table with all the info I wanted
Rank: is the table where I'm trying to have everything sorted (after this part of the script works I would add some ranking info)
The code i built is this:
Binary [c:\users\fernando.pinto\desktop\fdo\qlikview\modelos\al 15-02\compras fi pruebas fernando.qvw];
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='en-GB';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
SET QVDPATH='c:\users\fernando.pinto\desktop\fdo\qlikview\modelos\al 15-02\compras fi pruebas fernando.qvw';
TablaMaterial:
LOAD Material as 'CodigoSAP',
Familia as 'Familia_Material',
Descripcion as 'Description_Mat',
CodMaterialSAP as 'Material_MATNR'
FROM
[L:\01_Administracion y Finanzas\03_Control de Gestion\01_Comun\Fernando Pinto\Qlikview\Tablas\Maestro Inventario SAP.xlsx]
(ooxml, embedded labels, table is Hoja1);
Load
MATKL,
Material_MATNR,
MFRPN
Resident MARA;
Left Join(TablaMaterial)
LOAD
Material_MATNR;
TEMP:
Load *
Resident Ineficiencia;
Join (LFA1)
Load
proveedor_LIFNR,
NAME1 as Nombre_Proveedor;
Tabla:
NoConcatenate
load *
Resident TEMP;
Drop Table TEMP;
RANK:
Load
Nombre_Proveedor,
PERIODOPROVEEDOR,
RowNo() as Rank
Resident TEMP
ORDER BY PERIODOPROVEEDOR DESC;
But I get errors that it doesn't find the tables I created ...
