Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Tr y this - Sum(TOTAL <ProductID, OrderID, Supplier> Total)
Tr y this - Sum(TOTAL <ProductID, OrderID, Supplier> Total)
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?