Summing rows based on a field match between rows

[Benh09]

Hi all,

I am working on a visualization for summing the balance shown on a letter based on how many accounts are on said letter. Essentially i have a table like this:

I want to sum the AmountDue where the rows = Consumer A, again at Consumer B, again at Consumer C and so on. I have tried everything to my currently limited knowledge along with combing through the forum but I have been unable to find an answer. Is this possible in Qlik or should i rework the dataset to sum the values before loading it into Qlik? Thanks for any help.

[savioricardog]

Hi @Benh09 

Do you wanna something like this?

[robert_mika · Accepted solution]

Try: 

Sum(Aggr(Max(AmountDue), Consumer, LetterID))

[Benh09]

This worked perfectly, thank you so much. I was using Sum(Aggr but i was unaware i could use the max function to essentially create a temporary table which i could then sum from. Very clever, thank you!

[robert_mika]

You are welcome. Happy to help