Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ecabanas
Contributor

Problem with this function

I have Two tables:

COSTES cames from an excel and has the standard product costs

SALESLINE: is a sql table, and I want to introduce the value COSTEUDCASTD  from table "costes" , I tryed this, but it doesn'y work...

Thank's in advance to eveyone!!!

Eduard

COSTES:

Directory;

LOAD [Código artículo] AS ITEMID,

     [Descripcion Articulo],

     [Precio Coste Ud] AS COSTEUDSTD,

     [Precio Coste UD CA]AS COSTEUDCASTD

FROM

[..\..\..\Data BI\Costes_Standard.xlsx]

(ooxml, embedded labels, header is 10 lines, table is Cost);

SALESLINE:

Load SALESID, ITEMID, SALESSTATUS, NAME, QTYORDERED, SALESPRICE, INVENTTRANSID, CUSTACCOUNT,EVE_AMOUNTMSTEXCLTAX, year(CREATEDDATETIME)AS ANO, Month(CREATEDDATETIME)AS Mes;

SQL SELECT SALESID,ITEMID,SALESSTATUS,NAME,QTYORDERED,SALESPRICE,INVENTTRANSID,CUSTACCOUNT,CREATEDDATETIME,EVE_AMOUNTMSTEXCLTAX

from DynamicsAx.dbo.SALESLINE;

inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

From COSTES;

1 Solution

Accepted Solutions

Re: Problem with this function

This is probably causing the error:

inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

From resident COSTES;

But when you load SALESLINE it will be joined on COSTES as both contain the field ITEMID. So you can leave it out all together.


talk is cheap, supply exceeds demand
4 Replies
MVP
MVP

Re: Problem with this function

COSTES is a resident table, so try

inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

resident COSTES;

Re: Problem with this function

This is probably causing the error:

inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

From resident COSTES;

But when you load SALESLINE it will be joined on COSTES as both contain the field ITEMID. So you can leave it out all together.


talk is cheap, supply exceeds demand
ecabanas
Contributor

Re: Problem with this function

Hi swuehl, thank's fro your answer, but doing your answer I had this message:

not possible to open the file'C:\Users\eduard\Documents\COSTES' The system could not find the file

  inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

From COSTES

any idea?

thank's

ecabanas
Contributor

Re: Problem with this function

Hi Gysbert!!!

Thank YOU!!!!!!!!!!!!!!!!!!!!!!!

Community Browser