Erreur Group by

Tue, 17 Feb 2015 15:27:42 GMT

L'erreur lorque j'ai ajouter les fonction MAX et SUM

VL:

LOAD

CUSTOMER_TRX_ID as [VenteLigne. Pièce_ID],

INVENTORY_ITEM_ID as [VenteLigne. Article ID],

DESCRIPTION as [VenteLigne. Description Article],

if(IsNull(QUANTITY_CREDITED),0,QUANTITY_CREDITED)+if(IsNull(QUANTITY_INVOICED),0,QUANTITY_INVOICED) as [VenteLigne. Qté],

(UNIT_STANDARD_PRICE) as [VenteLigne. Prix_Theorique],

UNIT_SELLING_PRICE as [VenteLigne. Prix_de_Vente],

max((UNIT_STANDARD_PRICE))-sum(UNIT_SELLING_PRICE)*(if(IsNull(QUANTITY_CREDITED),0,QUANTITY_CREDITED)+if(IsNull(QUANTITY_INVOICED),0,QUANTITY_INVOICED)) as [VenteLigne. Remise],

UNIT_STANDARD_PRICE*(if(IsNull(QUANTITY_CREDITED),0,QUANTITY_CREDITED)+if(IsNull(QUANTITY_INVOICED),0,QUANTITY_INVOICED)) as [VenteLigne. Montant Brut],

if(INTERFACE_LINE_CONTEXT='INTERCOMPANY','Groupe','Hors Groupe') as [VenteLigne. Context],

INTERFACE_LINE_ATTRIBUTE1 as [VenteLigne. Num Cde],

EXTENDED_AMOUNT as [VenteLigne. Montant],

ORG_ID as [VenteLigne. SociétéID]

FROM

[..\QVD_Sources\RA_CUSTOMER_TRX_LINES_ALL.QVD]

(qvd)

Where

ORG_ID='155'

//or ORG_ID='158'

and (DESCRIPTION<>'Timbre Fiscal' and DESCRIPTION<>'Report')

and LINE_TYPE='LINE'

and (INTERFACE_LINE_CONTEXT='ORDER ENTRY' or INTERFACE_LINE_CONTEXT='INTERCOMPANY')

group by CUSTOMER_TRX_ID, INVENTORY_ITEM_ID

;

topic Erreur Group by in QlikView

Erreur Group by