topic Market Share in QlikView

Market Share

Mon, 25 Apr 2011 15:08:19 GMT

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?

Market Share

Anonymous — Mon, 25 Apr 2011 15:15:20 GMT

sum(Revenue)/sum(TOTAL <Region> Revenue)

Market Share

Mon, 25 Apr 2011 15:33:28 GMT

Check what I did based on your help, but it's only showing the value 1, even if I select or not the company:

=sum([Claim Total])/sum(TOTAL <[World Region]> [Claim Total])

How can I solve it?

Market Share

Anonymous — Mon, 25 Apr 2011 15:45:00 GMT

Can you upload the qvw so that I can have a look?

Thanks,

Dinesh.

Market Share

erichshiino — Mon, 25 Apr 2011 16:33:23 GMT

Try this:

=sum([Claim Total])/

sum( {< Company= , [World Region]={$(=only( [World Region])) }>} [Claim Total])

Market Share

Mon, 25 Apr 2011 17:53:20 GMT

No, It didn't worked... it's only showing -

Thanks

Market Share

erichshiino — Mon, 25 Apr 2011 18:15:37 GMT

Try this then:

=sum([Claim Total])/sum( {< Company = , [World Region]={$(=concat(distinct [World Region], ',')) }>} [Claim Total])

It may not work if your world region has spaces in the text (like "South America"), in that case, you would have to change the concat expression...

Market Share

Mon, 25 Apr 2011 20:00:30 GMT

It's not working again.

If all selections are clear, the result is 2,72049... and if I choose one company, the result is -

But I know that this company has revenue.

Thanks again for all your support Erich

Market Share

erichshiino — Mon, 25 Apr 2011 20:14:07 GMT

Do you prefer to send a sample application so we can build the expression with your real data?

You can use scramble or data reduction for this

Market Share

Tue, 26 Apr 2011 15:38:52 GMT

Yes,

I've prepared an example for you

It's not my DB, but its very similar.

Thanks for your attention

Market Share

Tue, 26 Apr 2011 15:41:02 GMT

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

Market Share

Tue, 26 Apr 2011 15:43:12 GMT

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!

Market Share

Anonymous — Tue, 26 Apr 2011 17:09:35 GMT

This worked for me:

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

Regards,

Dinesh.

Market Share

erichshiino — Tue, 26 Apr 2011 17:46:08 GMT

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),'###,#%', ',' ,'.' )

Market Share

Tue, 26 Apr 2011 18:04:54 GMT

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

Market Share

Tue, 26 Apr 2011 19:15:58 GMT

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

Re: Market Share

Fri, 23 Jan 2015 07:51:58 GMT

Hello Erich,

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