Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
groveliam
Contributor

% of Goal

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: Columns.PNG

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.

3 Replies
groveliam
Contributor

Re: % of Goal

Do you know any ways? stalwar1

lfholland
New Contributor III

Re: % of Goal

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)

DavidŠtorek
Contributor III

Re: % of Goal

Hi,

check attached app. I hope it will be helpfull for you