topic Add line items together in App Development

Add line items together

Anonymous — Thu, 29 Nov 2018 03:46:55 GMT

This is a sample of the data I load

ProductID	OrderID	Supplier	Total
77	80100	Advantage Parts Solutions	$5,025
77	80100	Advantage Parts Solutions	$5,025
77	80100	Advantage Parts Solutions	$5,025

I want to create a Qlik Sense table with an expression that will sum the 3 line items from the sample above to equal $15,075, however when I attempt to do so, with my current expressions, below is the Qlik Sense table I produce.

ProductID	OrderID	Supplier	Sum(Distinct[Total])	Sum([Total])
77	80100	Advantage Parts Solutions	$5,025	$45,225

Can you help?

Re: Add line items together

Anil_Babu_Samineni — Thu, 29 Nov 2018 05:08:59 GMT

Tr y this - Sum(TOTAL <ProductID, OrderID, Supplier> Total)

Re: Add line items together

tresB — Thu, 29 Nov 2018 06:03:05 GMT

This seems to be a data model issue. If you load only this table using INLINE, the problem should not be there. Could you try that and let know?