topic Re: Estimate Market Share in QlikView

Estimate Market Share

danialier — Wed, 15 Jan 2014 10:30:50 GMT

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

Re: Estimate Market Share

jvishnuram — Wed, 15 Jan 2014 10:36:42 GMT

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%')

Re: Estimate Market Share

Wed, 15 Jan 2014 10:46:51 GMT

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

Re: Estimate Market Share

Wed, 15 Jan 2014 10:51:03 GMT

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

Re: Estimate Market Share

kiranmanoharrode — Wed, 15 Jan 2014 10:52:31 GMT

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

Re: Estimate Market Share

danialier — Wed, 15 Jan 2014 12:14:27 GMT

excellent Shruti, it works now !

many thanks !

Re: Estimate Market Share

Fri, 23 Jan 2015 07:42:58 GMT

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