Bank Performance Dashboard

[msbhuvanesh003]

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.

[passionate]

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

[OmarBenSalem · Accepted solution]

Just use a pie chart

As dimension bank

As measure sum(amount)

[msbhuvanesh003]

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.

[msbhuvanesh003]

Dear Omar,

please find the attachment for your reference.

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 %)

[msbhuvanesh003]

Dear Omar ,

Any update on this expression ?

this is an urgent requirement so please help me.

[Anonymous]

Hi

I hope it´s no too late.

Here is my suggestion.

Good luck

[Mrunal_Borude]

Please find attached QVF .