Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
johnbowie
New Contributor II

Add line items together

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?

1 Solution

Accepted Solutions
Highlighted

Re: Add line items together

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Highlighted

Re: Add line items together

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
MVP
MVP

Re: Add line items together

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?