topic Sum of Certain Rows in straight Table in QlikView

Sum of Certain Rows in straight Table

fheidenstecker — Mon, 05 Oct 2015 17:28:10 GMT

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

Re: Sum of Certain Rows in straight Table

Gysbert_Wassenaar — Mon, 05 Oct 2015 17:46:19 GMT

See attached qvw

Re: Sum of Certain Rows in straight Table

fheidenstecker — Mon, 05 Oct 2015 18:51:23 GMT

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

Re: Sum of Certain Rows in straight Table

Gysbert_Wassenaar — Tue, 06 Oct 2015 05:59:06 GMT

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.

Re: Sum of Certain Rows in straight Table

fheidenstecker — Tue, 13 Oct 2015 08:25:38 GMT

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