# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## Bank Performance Dashboard

Hi Friends,

I need a help.

I want to find out the particular bank performance or contribution in india.

Example:

Money Sending Country Name Money Receiving Country Name Bank Name Total Amount
Global India SBI 1000
Global India ICICI 2000
Global India IDBI 3000
Global India HDFC 4000
Global India HSBC 5000

above table shows globally money received from india's different banks.

I want to find out the contributions of ICICI bank india.

Total Amount received to india 15000

contribution of ICICI 2000 13%

rest of the bank contribution 13000 87%

I want to present these performance for using pie chart.

I want the expression for this calculation in qlik sense.

friends kindly share the expression for above calculation.

1 Solution

Accepted Solutions
Esteemed Contributor

## Re: Bank Performance Dashboard

Just use a pie chart

As dimension bank

As measure sum(amount)

6 Replies
Valued Contributor

## Re: Bank Performance Dashboard

Is ICICI Bank fix dimension or you want list box for Banks?

Esteemed Contributor

## Re: Bank Performance Dashboard

Just use a pie chart

As dimension bank

As measure sum(amount)

New Contributor II

## Re: Bank Performance Dashboard

Dear Pankaj,

I have more than 150 bank list are there.

when select the particular bank like icici in the list box the pie chart should be the contributions of icici and rest of banks contribution.

Pie chart:

Raw Data:

Total Txn happened in india is 87862

contribution of icici 39317

rest of banks in india 48545

I need the expression for above calculation.

when I select the other bank answer should be like % of contribution and % of rest of bank contribution.

New Contributor II

## Re: Bank Performance Dashboard

Dear Omar,

calculation:

 icici total txn 369,914 txn happened in india 1,462,534 contribution of icici 369,914 25% rest of india or other bank 1,092,620 75%

when I select the particular bank in list box the answer should be the above calculation for all other bank.

I want to project both contribution (particular bank % and rest of banks total %)

New Contributor II

## Re: Bank Performance Dashboard

Dear Omar ,

Any update on this expression ?