Qliksense Stack bar chart percentage issue

[Aspiring_Developer]

Hello All,

I have below data set :-

Dimension - Monthname (coming from master calendar)

Measure - We have 4 measures here :-

1)Sum({<Brand={'BT'}>}Value)/Sum({<Brand={'Total Market'}>}Value)-- BT

2)Sum({<Brand={'Plusnet'}>}Value)/Sum({<Brand={'Total Market'}>}Value)- Plusnet

3)Sum({<Brand={'EE'}>}Value)/Sum({<Brand={'Total Market'}>}Value)-- EE

4) 1-(Sum({<Brand={'Plusnet','BT','EE'}>}Value)/Sum({<Brand={'Total Market'}>}Value))- ROM

Now I have given filters at the top for brand, type , date like below :-

Now my problem is that since I have specified the values of brand and type in set analysis expression , I am unable to filter them . What I wish to achieve is that these charts should sync up with with these filters . As of now , only my date filter is linked with these visualizations.

Not sure, how can I achieve it . Can anyone please help ?

Thanks in advance

[Aspiring_Developer]

Can anyone please help on this ? 

@sunny_talwar @Anonymous 

[justISO]

Hi, are you tried not to make separate measures for each Brand, but make general stacked graph

where measure looks like this

Sum(Value) / Sum(total <Monthname> {1} Value)

In this way filters should work without problem.

[RsQK]

Hi, if i understood correctly, try these expressions:

1)Sum({<Brand*={'BT'}>}Value)/Sum({<Brand*={'Total Market'}>}Value)-- BT

2)Sum({<Brand*={'Plusnet'}>}Value)/Sum({<Brand*={'Total Market'}>}Value)- Plusnet

3)Sum({<Brand*={'EE'}>}Value)/Sum({<Brand*={'Total Market'}>}Value)-- EE

4) 1-(Sum({<Brand*={'Plusnet','BT','EE'}>}Value)/Sum({<Brand*={'Total Market'}>}Value))- ROM