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 ...
When you create the table "TEMP" use NoConcatenate If you don't use Noconcatenate your table Temp is concatenating with the table Ineficiencia and the table TEMP will never exist
