Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached qvw
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
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.
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