topic Semi additive measure in QlikView

Semi additive measure

Anonymous — Wed, 19 Jul 2017 21:41:50 GMT

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:

Has anyone had any experience with this type of expression?

Thanks

sunny_talwar — Wed, 19 Jul 2017 23:13:24 GMT

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 — Thu, 20 Jul 2017 00:05:23 GMT

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 — Thu, 20 Jul 2017 03:16:38 GMT

May be something like this? Havent Tried

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

sunny_talwar — Thu, 20 Jul 2017 14:14:37 GMT

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

vishsaggi — Thu, 20 Jul 2017 14:18:34 GMT

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

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