Market Share

[#1]

Dears,

Now I want to create a Market Share chart.

The first chart is the Market share of one company on it's region
This chart will show the revenue of one specific company (selected in a list box) in comparison with the total revenue of it's region.

The secound chart is the Market Share of one company compared with all companies
This chart will show the revenue of one specific company (selected in a list box) in comparison with all of the others companies.

The problem is that when I choose the company the sistem should count the total of this Company and count the total of the region, and then devide.

Example:
Company 1 is in the region A

So, the formula should count the total of company 1 and devide by the total of region A

How can I do it?

[#2]

What I want to know is:

What is the Market Share?

If nothing is select, the number should be 1 or 100%.

If you choose by car model, it will give you the Market Share of that specific car that you have select.

If you choose by region, the same, and even if you select by company.

Thanks

[#3]

And what is the Market share?

It is the (total revenue of your selection) / (total global revenue revenue from your all data)

Sorry for this multiple posts,

My computer is being crazy!

[Anonymous]

This worked for me:

=sum(Revenue * 100 )/sum(all Revenue)

Regards,

Dinesh.

[erichshiino]

Since you are trying to put it on a text box, it's better to format the number.

The {1} basically ignores the selection

'All' on the other post means {1}Total (ignores selection and object dimensions

=num( sum(Revenue)/sum({1}Revenue),'###,#%', ',' ,'.' )

[#6]

Now, insted of Claim Total, I need to insert the expression:

=Num(sum({<UNIQUE_FLAG={1}>}[PO Total]*pick(match([Currency],'EUR','USD','BRL'),EUR,USD,BRL)),'USD #,##0.00', '.',',')

and in order to reduce the expression size, what's the best way to write it?
like, can I declare it before?

How can I do it faster?

Thanks

[#7]

Dears,
I'm trying to use this formula to show the Market Share.

But if I choose a company, the result is always 100%, and it's wrong. What is going on?

=num( SUM({<UNIQUE_FLAG={1}, [Status Claim] -={Cancelled}>}([Claim Total])*pick(match([Currency],'EUR','USD','BRL'),EUR,USD,BRL))/sum({1}{<UNIQUE_FLAG={1}, [Status Claim] -={Cancelled}>}([Claim Total])*pick(match([Currency],'EUR','USD','BRL'),EUR,USD,BRL)),'###,#%', ',' ,'.' )

Thanks

[#8]

Hello Erich,

Please suggest on this post: http://community.qlik.com/message/700251#700251