Region Wise share

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I have a chart in which i show brand wise share . When no Region is Selected it shows at All India Level which is correct as per below.

Dimension Expression :=if(getselectedCount(Region)>0,Region,'All India')

Expression Used:

=sum({<LinkCommonDate={">=$(vLast2MonthMinDate)<=$(vLast2MonthMaxDate)" },Year=,Month= >}$(vMeasureSales))/

Sum(TOTAL {<LinkCommonDate={">=$(vLast2MonthMinDate)<=$(vLast2MonthMaxDate)"},CompetitorName=,Year=,Month=>}$(vMeasureSales))

Region	Brand	Dealer Count	Jul17	Aug17	Sep17	Week38	Week37	Week36	Week35	Jul	Aug	Sep
All India		23319	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	0.0%	0.0%	0.0%
All India	SAMSUNG	23225	52.0%	55.5%	58.8%	61.2%	56.9%	58.9%	58.2%	3.2%	3.5%	3.3%
All India	VIVO	21177	13.2%	11.4%	12.3%	12.7%	13.9%	11.0%	10.9%	-0.4%	-1.8%	0.9%
All India	OTHERS	21177	12.2%	10.4%	9.4%	8.4%	9.5%	10.0%	9.8%	0.8%	-1.8%	-0.9%
All India	OPPO	21177	11.6%	10.2%	8.6%	8.0%	8.5%	8.7%	9.2%	-1.0%	-1.4%	-1.6%
All India	APPLE	21177	5.1%	5.1%	3.7%	3.3%	3.7%	3.8%	4.3%	-1.7%	0.0%	-1.4%
All India	GIONEE	21177	3.2%	2.9%	2.5%	2.2%	2.5%	2.6%	2.7%	-0.5%	-0.3%	-0.4%
All India	MICROMAX	21177	1.3%	1.4%	1.2%	1.0%	1.3%	1.4%	1.3%	0.0%	0.0%	-0.1%
All India	LAVA	0	1.1%	0.3%	0.0%	0.0%	0.0%	0.0%	0.0%	-0.1%	-0.8%	-0.3%
All India	LYF	21177	0.2%	0.2%	0.1%	0.1%	0.1%	0.1%	0.1%	-0.2%	0.0%	0.0%
All India	HTC	0	0.2%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	-0.1%	-0.1%	0.0%
All India	XIAOMI	21177	0.0%	2.8%	3.3%	3.1%	3.5%	3.4%	3.4%	0.0%	2.8%	0.5%

Now i want my expression to show Region wise contribution when i drill down on Region :

I want Like below

Region	Brand	Dealer Count	Jul17	Aug17	Sep17	Week38	Week37	Week36	Week35	Jul	Aug	Sep
EAST 1	SAMSUNG	2595	53.0%	56.9%	59.7%	60.2%	58.9%	60.3%	59.2%	2.4%	3.9%	2.8%
EAST 1	VIVO	2366	13.1%	10.4%	10.7%	11.5%	11.3%	9.8%	10.0%	-0.3%	-2.7%	0.3%
EAST 1	OTHERS	2366	11.2%	11.3%	11.2%	10.6%	11.0%	11.9%	11.6%	0.3%	0.1%	-0.1%
EAST 1	OPPO	2366	10.8%	8.8%	7.5%	7.6%	7.6%	7.0%	7.6%	-1.0%	-2.0%	-1.3%
EAST 1	GIONEE	2366	6.0%	5.7%	5.0%	4.8%	4.9%	5.1%	5.3%	-0.8%	-0.4%	-0.7%
EAST 1	APPLE	2366	2.4%	2.4%	1.5%	1.2%	1.6%	1.5%	1.7%	-0.4%	0.0%	-0.9%
EAST 1	MICROMAX	2366	2.1%	2.2%	2.1%	1.9%	2.1%	2.3%	2.3%	0.0%	0.1%	-0.1%
EAST 1	LAVA	0	1.0%	0.3%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	-0.7%	-0.3%
EAST 1	HTC	0	0.2%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	-0.1%	-0.1%	0.0%
EAST 1	LYF	2366	0.1%	0.1%	0.1%	0.1%	0.1%	0.1%	0.1%	-0.1%	0.0%	0.0%
EAST 1	XIAOMI	2366	0.0%	1.9%	2.3%	2.2%	2.6%	2.0%	2.3%	0.0%	1.9%	0.3%
EAST 2	SAMSUNG	2494	58.4%	64.3%	64.0%	65.3%	62.8%	63.9%	65.4%	2.0%	5.9%	-0.3%
EAST 2	OPPO	2302	11.1%	8.9%	8.2%	7.9%	8.1%	8.3%	8.3%	-0.9%	-2.2%	-0.7%
EAST 2	VIVO	2302	11.0%	9.0%	10.3%	10.8%	11.3%	9.3%	8.9%	-0.4%	-2.1%	1.3%
EAST 2	OTHERS	2302	10.4%	9.4%	9.5%	9.0%	9.7%	9.9%	9.3%	1.4%	-0.9%	0.1%
EAST 2	GIONEE	2302	3.9%	3.3%	3.0%	2.8%	3.0%	3.1%	3.1%	-0.5%	-0.6%	-0.3%
EAST 2	MICROMAX	2302	1.9%	1.8%	1.6%	1.3%	1.6%	1.7%	1.7%	-0.1%	-0.1%	-0.3%
EAST 2	APPLE	2302	1.8%	1.4%	1.5%	1.2%	1.5%	1.7%	1.5%	-0.8%	-0.3%	0.0%
EAST 2	LAVA	0	1.1%	0.3%	0.0%	0.0%	0.0%	0.0%	0.0%	-0.1%	-0.8%	-0.3%
EAST 2	LYF	2302	0.3%	0.2%	0.2%	0.1%	0.2%	0.2%	0.2%	-0.4%	-0.1%	0.0%
EAST 2	HTC	0	0.1%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	-0.1%	0.0%
EAST 2	XIAOMI	2302	0.0%	1.3%	1.8%	1.6%	1.8%	1.9%	1.7%	0.0%	1.3%	0.5%

But what i m getting is Example: Bifercation of 52.0 % of Samsung from All India( chart 1st) .In East 1:- 4.2, East 2:- 4.3 so on which is wrong .

Please help .

Region	Brand	Dealer Count	Jul17	Aug17	Sep17	Week38	Week37	Week36	Week35	Jul	Aug	Sep
-	-	23319	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	0.0%	0.0%	0.0%
EAST 2	SAMSUNG	2494	4.3%	4.4%	4.0%	4.0%	3.9%	4.1%	4.4%	1.0%	0.1%	-0.3%
NORTH 3	SAMSUNG	2680	5.9%	6.1%	5.7%	5.6%	5.1%	6.1%	6.4%	-0.2%	0.2%	-0.3%
WEST 4	SAMSUNG	1346	2.4%	3.0%	2.8%	2.8%	2.5%	2.8%	2.9%	0.8%	0.6%	-0.2%
NORTH 2	SAMSUNG	1924	3.6%	4.0%	3.9%	4.5%	3.4%	3.8%	4.0%	-0.2%	0.3%	-0.1%
NORTH 1	SAMSUNG	2037	4.5%	4.9%	4.9%	5.4%	4.6%	4.6%	4.7%	-0.2%	0.4%	-0.1%
NORTH 4	SAMSUNG	1473	3.7%	3.9%	4.2%	4.3%	4.0%	4.2%	4.3%	0.2%	0.2%	0.2%
WEST 2	SAMSUNG	1600	3.9%	4.6%	5.0%	6.1%	4.9%	4.3%	4.1%	0.5%	0.7%	0.2%
WEST 1	SAMSUNG	2939	8.8%	9.3%	9.7%	9.9%	9.9%	9.3%	9.0%	0.1%	0.5%	0.3%
SOUTH 3	SAMSUNG	1344	3.0%	3.2%	3.5%	3.8%	3.4%	3.4%	3.4%	0.3%	0.3%	0.3%
SOUTH 2	SAMSUNG	1295	3.5%	3.8%	4.0%	4.1%	3.9%	4.1%	3.9%	0.1%	0.3%	0.3%
EAST 1	SAMSUNG	2595	4.2%	4.7%	5.7%	6.0%	5.8%	5.5%	5.3%	0.3%	0.5%	1.0%
SOUTH 4	SAMSUNG	542	1.3%	1.8%	2.6%	2.0%	2.2%	3.0%	3.1%	0.1%	0.4%	1.1%
SOUTH 1	SAMSUNG	956	2.9%	1.9%	3.1%	2.7%	3.1%	3.8%	2.8%	0.3%	-1.0%	1.1%

Re: Region Wise share

swuehl — Sun, 24 Sep 2017 10:24:45 GMT

Try

=sum({<LinkCommonDate={">=$(vLast2MonthMinDate)<=$(vLast2MonthMaxDate)" },Year=,Month= >}$(vMeasureSales))/

Sum(TOTAL<Region> {<LinkCommonDate={">=$(vLast2MonthMinDate)<=$(vLast2MonthMaxDate)"},CompetitorName=,Year=,Month=>}$(vMeasureSales))

Re: Region Wise share

Anonymous — Sun, 24 Sep 2017 10:47:34 GMT

Thanks , i m checking the same . Also please tell :-

when i drill down on region i get all regions but in tolat row ,Column Region is blank when no region is selected . When no region is selected then also i need ALL INDIA after drill down

dimension Expression:-

if(getselectedCount(Region)>0,Region,'All India')

topic Re: Region Wise share in QlikView

Region Wise share

Re: Region Wise share

Re: Region Wise share