topic Re: very tricky scenario... in QlikView

very tricky scenario...

Sat, 19 Dec 2015 19:11:20 GMT

I need following KPI

Count of codes

Percent share of codes per brand

Percent share of over all codes

Tricky is when i applied filter on brand , Percent share of all codes is becoming brand wise percent How to controll this.

HirisH_V7 — Sun, 20 Dec 2015 07:10:22 GMT

Hi ,

I hope i understood your requirement partially or what ,

I think this is what you are expecting.

PFA,

Hope this Helps,

Regards,

Hirish

settu_periasamy — Sun, 20 Dec 2015 08:27:45 GMT

Hi,

May be like attached?

effinty2112 — Sun, 20 Dec 2015 15:31:43 GMT

Hi Uday,

The expression in this table will disregard user selections of Brand

Brand	Count(DISTINCT code)/count({$<Brand=>}TOTAL DISTINCT code)
	100.00%
A	66.67%
B	33.33%

If we select Brand 'A' the table returns

Brand	Count(DISTINCT code)/count({$<Brand=>}TOTAL DISTINCT code)
	66.67%
A	66.67%