Estimate Market Share

[danialier]

Hello,

I want to estimate the market share for an specific country (USA) for all vendors, so this is to divide the units of each vendor in USA by the total of units in USA. I'm using the following formula but what i get is always 100% share which is not correct...

= num(sum({<COUNTRY={'USA'},VENDOR>}UNITS)/sum({<COUNTRY={'USA'}>}UNITS)*100,0.0)&'%'

Please help !

dani

[jvishnuram]

Hi Dani,

I don't know the entire scenario but your set analysis is wrong, it should be

num((sum({<COUNTRY={'USA'}>}UNITS)/sum(Total {<COUNTRY={'USA'},VENDOR=>}UNITS))*100,'##,##.00%')

[#3]

Hi,

I would do:

= num(sum({<COUNTRY={'USA'}>}UNITS)/sum({<COUNTRY={'USA'}, VENDOR= >}UNITS)*100,0.0)&'%'

The second part should have ALL vendors, not the first part.

Fabrice

[#4 · Accepted solution]

Hi,

Try using sum(TOTAL{<COUNTRY={'USA'}>}UNITS) in denominator. And Using Vendor in set analysis will bypass vendor so it must be giving same value in numerator and denominator.

Can u please post QVW??

-Shruti

[kiranmanoharrode]

Hello Dani,

Put Below expression in streight table with Vendor as a Dimension. this may solve an issue.

=Max(aggr(sum({<COUNTRY={'USA'}>}UNITS),VENDOR))*100,0.0) / Sum(Aggr(sum({1<COUNTRY={'USA'},>}UNITS)VENDOR))&'%'

Regards,

Kiran Rode

+91 897 69 77 897

[danialier]

excellent Shruti, it works now !

many thanks !

[#7]

Hello Fabrice, Please suggest on post: http://community.qlik.com/message/700251#700251