Newbie question

FPC — Wed, 20 Feb 2019 14:22:07 GMT

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 ...

Re: Newbie question

m_woolf — Wed, 20 Feb 2019 14:36:31 GMT

Many times when a table is not found, it means that the table needs a noconcatenate in front of load.

Re: Newbie question

andrescc — Thu, 21 Feb 2019 05:53:24 GMT

Hi,

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

Regards,
ACC

Re: Newbie question

FPC — Fri, 22 Feb 2019 14:38:08 GMT

Thx for the answer, but can you show me how the code should look like, I'm kind of confused, because it still shows errors.

topic Newbie question in QlikView

Newbie question

Re: Newbie question

Re: Newbie question

Re: Newbie question