Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Halebabür
Contributor III
Contributor III

How to write total amount in different Documents in QSense

Hi,

How to write total amount in different Documents in QSense

Halebabr_0-1668674641869.png

 

For example, the sum of Posnr 00080 and 00090 should be 560. But these expressions give 280.

Sum(Aggr(Sum( farklı VBAP_KWMENG), "Belge Numarası"))

1 Solution

Accepted Solutions
Halebabür
Contributor III
Contributor III
Author

sum(aggr(sum(DISTINCT [Sales]), [ID]))

View solution in original post

5 Replies
vinieme12
Champion III
Champion III

just use 

Sum( VBAP_KWMENG)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Halebabür
Contributor III
Contributor III
Author

Teşekkürler ama ne yazık ki o zaman tüm satırları özetliyor.

The result should be 560

Halebabr_0-1668680168220.png

 

 

 

vinieme12
Champion III
Champion III

Please provide some sample data or sample app

I've no clue what your data is like/about   so some information on your data would also be helpful

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Halebabür
Contributor III
Contributor III
Author

I have 560 sales. This is how the table looks as I make deliveries in parts. How can I find the order total?

Halebabür
Contributor III
Contributor III
Author

sum(aggr(sum(DISTINCT [Sales]), [ID]))