Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ecabanas
Contributor

Problema Select INNERJOINT de dos tablas urgente de novato ;-)

Hola a todos,

Soy novato y estoy empezando y tengo la siguiente duda:

Tengo una tabla que son los movimientos de ventas de mis articulos (Salesline), pero quierria cargales a cada linea su coste standard que tengo en una tabla (COSTES).

Querria que se cargara el coste y encima crear un calculo (unidades [QTYORDERED] * Precio standard [COSTEUDCASTD] )

MUUUUUCHAS gracias

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, COSTEUDCASTD;

SQL SELECT

      SALESID,ITEMID,SALESSTATUS,NAME,QTYORDERED,SALESPRICE,INVENTTRANSID,CUSTACCOUNT,CREATEDDATETIME,EVE_AMOUNTMSTEXCLTAX,COSTESANALITICOS.COSTAMOUNTPOSTED

from DynamicsAx.dbo.SALESLINE

INNERJOINT COSTEUDCASTD ON ITEMID=COSTES.ITEMID;

Community Browser