topic Re: Market Share calculation in QlikView

Market Share calculation

danialier — Tue, 18 Mar 2014 14:46:34 GMT

Hello,

I want a List Box to show the market share of different companies based on the country I select in a Text Box. The formula I use is the following one but it does not work... Please help.

=num(sum({<Company=>}units))/num(sum(units))

thks,dani

Re: Market Share calculation

MK_QSL — Tue, 18 Mar 2014 14:51:38 GMT

SUM({<Company = >}units)/sum({1}units)

NUM(SUM({<Company = >}units)/sum({1}units),'#,##0.00%')

Re: Market Share calculation

hic — Tue, 18 Mar 2014 14:51:43 GMT

Not sure what you really want... A list box does normally not show a calculation and you cannot make a selection in a text box.

But - If you show the market shares in a chart where you have Companies as dimension, you can calculate the market shares through

Sum(units) / Sum(total units)

HIC

Re: Market Share calculation

maxgro — Tue, 18 Mar 2014 14:52:38 GMT

perhaps you want the market share in a chart

and you select the country in a listbox?

Re: Market Share calculation

jonathandienst — Tue, 18 Mar 2014 14:54:17 GMT

I assume that there is an association between country and company? I would put Country in a list box and show the market share in a pivot or straight table.

Is the market share by country, or for all countries?

Your expression will be something like (share by country):

=Sum(units) / Sum(Total Units)

or (share for all countries)

=Sum(units) / Sum({<Country=>}Total Units)

The num() function does nothing in these expressions, it just changes the display format of the number.

HTH

Jonathan

Re: Market Share calculation

bgerchikov — Tue, 18 Mar 2014 15:03:44 GMT

Hi Dani,

Try this one:

SUM(units)/SUM(TOTAL <Country> units)

Hope it will help

Re: Market Share calculation

its_anandrjs — Tue, 18 Mar 2014 15:09:08 GMT

Hi,

Create a chart based on the Market share and display that one and use list box for country and other selection would be better idea.

Use expression like

=num(sum(units)) / num(sum(Total units))

Thanks & Regards