Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Everyone,
On Qlik Sense I have 2 tables, Deposits and Goals. I need to take the sum of all the balances and divide them by the goal defined in the goal table. The goals are based on Region and Account Type. Below is how the table is to be set up:
I then need a new column to the right that displays the percentage on how close the sum of the balances are to the goal. Is there a way to connect the tables in the load script? Or can it be done on the front end? I will attach sample data as well. Any help is appreciated!
Thanks,
Liam Grover
P.S. I cannot use If statements for what I am doing, because I am also including sparklines from VizLib and cannot have if statements in the table. So I believe it should be set analysis or something.
Do you know any ways? stalwar1
Try this (I used the column headers in your xls files)
Sum(TOTAL <GovAccType, [Branch Region]> [Current Balance])
/
Sum(TOTAL <GoalsGovAccType, [Goals Branch Region]> GOALS)
Hi,
check attached app. I hope it will be helpfull for you