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: 
Anonymous
Not applicable

Semi additive measure

I'm working with account balances, and I can't quite get the semi-additive expression to work.

I would like to sum the latest balances for each account #  and id for the selected date range.


example:

Acct #IdPost DateSequence #Balance
Total$43,835.03
0000000045086/30/20171812224$18,330.17
0000000045085/31/20171692314$18,307.74
0000000045084/30/2017840965$18,284.60
0000000045083/31/20171781804$18,262.23
0000000045082/28/20171856632$18,239.14
0000000045081/31/20171617917$18,218.31
0000000101606/30/20171812256$25,504.86
0000000101605/31/20171692322$25,473.66
0000000101604/30/2017840982$25,441.46
0000000101603/31/20171781836$25,410.34

Has anyone had any experience with this type of expression?

Thanks

5 Replies
sunny_talwar

Is this how you want to see in a chart or are you just looking to get the total in a text box object?

Anonymous
Not applicable
Author

Sorry I should have been more specific. I'd like to see it in a straight table. Thanks

Sent from my Sprint Samsung Galaxy S7.

vishsaggi
Champion III
Champion III

May be something like this? Havent Tried

= Sum(TOTAL {< [Post Date] = { "$(= Max([Post Date]))" } >} Balance)

sunny_talwar

Rowwise you want to see everything, but total should only include the most recent value?

vishsaggi
Champion III
Champion III

What are you expecting to look in this straight table like below?

Capture.PNG

= Sum(TOTAL <[Acct #], Id> {$< [Post Date] = { "$(= Max([Post Date]))" } >} Balance)