Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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%')
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
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
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
excellent Shruti, it works now !
many thanks !
Hello Fabrice, Please suggest on post: http://community.qlik.com/message/700251#700251