Sum of Certain Rows in straight Table

[fheidenstecker]

Hi Qlik Community,

I have a problem with making a calculation in a straight table. At first, this requirement sounded quite trivial to me, but turned out to be a real brain twister 🙂

I have a table with accounts and sum ammounts. Each account has a reference account. I want to have a table column with the total amount of the reference account, and then later devide it to build a rate.

I am expecting the sum of 4.175.159 for those rows who have the reference account 5000 and the one that has the reference Account 6660 i expect the sum of 440.541

I did some trial and error, but i can't get it to work.

I attached a demo file

I really would appriciate some help!

Cheers from Germany,

Fabian

[Gysbert_Wassenaar]

See attached qvw

[fheidenstecker]

Thanks Gysbert,

but in my real application I need to do the calculation based on the users selection. So i need a more dynamic approachm because i doubt i can do the calculation in the script 😞

Fabian

[Gysbert_Wassenaar · Accepted solution]

Well, I doubt this can be done with chart expressions in a sane way. All you need to do in the script is associate the accounts with the reference accounts like I did in my example. You don't need to modify your script in any other way. User selections should work just fine.

[fheidenstecker]

Hi Gysbert,

i solved it by doing all the calculations in the script.

My real application is way more complex than the example that I uploaded here.

Thanks for your input 🙂

Best regards,

Fabian