topic how to find contribution ? in QlikView

how to find contribution ?

msbhuvanesh003 — Wed, 25 Nov 2020 16:16:04 GMT

Dear Experts,

I want to find out the contributions of particular bank transaction.

I have more than 150 bank from various countries.

When I select one bank from the filter pane the pie chart will shows transaction contribution of the bank and rest bank transaction for the country.

Could you please share the expression for the calculation for build the pie chart.

I have attached the requirement for your reference.

Kindly share the calculation expression ASAP.

Sample Result:

Re: how to find contribution ?

sunny_talwar — Wed, 14 Feb 2018 17:41:08 GMT

May be using two expressions

1) Sum(Transactions)

2) Sum({<Bank>} Transactions) - Sum(Transactions)

Re: how to find contribution ?

shiveshsingh — Thu, 15 Feb 2018 10:50:10 GMT

You can get idea from attached app

Re: how to find contribution ?

Peter_Cammaert — Thu, 15 Feb 2018 13:17:46 GMT

Maybe not the most elegant solution but it works. It works even for multiple selections vs. the others.

Re: how to find contribution ?

msbhuvanesh003 — Sun, 18 Feb 2018 06:12:37 GMT

Dear Shivesh,

I tried this also but not working.

any other expressions available.

Re: how to find contribution ?

msbhuvanesh003 — Sun, 18 Feb 2018 06:13:34 GMT

Sorry Sunny

Re: how to find contribution ?

msbhuvanesh003 — Mon, 19 Feb 2018 06:54:26 GMT

Dear All

please help me for find out the solution for this requirement.

Re: how to find contribution ?

Peter_Cammaert — Mon, 19 Feb 2018 08:25:33 GMT

Did you try the above example?

Re: how to find contribution ?

msbhuvanesh003 — Mon, 19 Feb 2018 08:36:40 GMT

Dear Peter

I tried many times but pie chart not showing the result.

Re: how to find contribution ?

Peter_Cammaert — Mon, 19 Feb 2018 08:43:10 GMT

Well, it does for me:

Care to post one of your attempts, so that we can have a look at your object and expressions?

Re: how to find contribution ?

msbhuvanesh003 — Mon, 19 Feb 2018 08:53:09 GMT

Dear Sir,

could you send me the expression which you used for this pi chart..

dimension ....

Measure ... expression

Re: how to find contribution ?

karthikoffi27se — Mon, 19 Feb 2018 08:54:51 GMT

Hi Bhuvaneshwaran,

Please find attached QVW with desired output.

Many Thanks

Karthik

Re: how to find contribution ?

msbhuvanesh003 — Mon, 19 Feb 2018 09:02:04 GMT

Karthick,

Qvw attachment is Not available...

Re: how to find contribution ?

Peter_Cammaert — Mon, 19 Feb 2018 09:05:23 GMT

Are you reading this from your Inbox? If so, open the thread in a full browser window and you will find all attachments to be available for download.

Re: how to find contribution ?

Peter_Cammaert — Mon, 19 Feb 2018 09:07:27 GMT

I already did provide you with all details. Just reopen the QVW and check the pie chart properties.

Re: how to find contribution ?

Peter_Cammaert — Mon, 19 Feb 2018 09:13:01 GMT

In case you didn't know, there is an example document attached to my post as well.

Check it out.

Re: how to find contribution ?

msbhuvanesh003 — Mon, 19 Feb 2018 10:01:06 GMT

Dear Peter,

I need a expression for Qlik sense app.

I tried to convert Qvw in qlik sense hub but its not working properly.

Kindly share the dimension & measure expression for qlik sense platform.

Re: how to find contribution ?

msbhuvanesh003 — Mon, 19 Feb 2018 10:24:53 GMT

Dear Peter,

thank you so much for your valuable solution.

finally its working fine.

thanks a lot.

Re: how to find contribution ?

msbhuvanesh003 — Mon, 19 Feb 2018 10:25:22 GMT

Dear Karthick,

thank you so much for your valuable solution.

finally its working fine.

thanks a lot.

Re: how to find contribution ?

msbhuvanesh003 — Mon, 19 Feb 2018 10:34:00 GMT

Dear Shivesh

thank you so much for your valuable solution.

finally its working fine.

thanks a lot.