Discussion board where members can get started with Qlik Sense.
I need a help.
I want to find out the particular bank performance or contribution in india.
Money Sending Country Name Money Receiving Country Name Bank Name Total AmountGlobal India SBI 1000Global India ICICI 2000Global India IDBI 3000Global India HDFC 4000Global 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.
Go to Solution.
Just use a pie chart
As dimension bank
As measure sum(amount)
Is ICICI Bank fix dimension or you want list box for Banks?
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.
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.
please find the attachment for your reference.
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 %)
Dear Omar ,
Any update on this expression ?
this is an urgent requirement so please help me.
I hope it´s no too late.
Here is my suggestion.