Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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]))