topic Re: Qliksense Stack bar chart percentage issue in App Development

Qliksense Stack bar chart percentage issue

Aspiring_Developer — Thu, 14 Jul 2022 12:57:11 GMT

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

Re: Qliksense Stack bar chart percentage issue

Aspiring_Developer — Fri, 15 Jul 2022 08:14:35 GMT

Can anyone please help on this ?

@sunny_talwar @Anonymous

Re: Qliksense Stack bar chart percentage issue

justISO — Fri, 15 Jul 2022 08:37:49 GMT

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.

Re: Qliksense Stack bar chart percentage issue

RsQK — Fri, 15 Jul 2022 08:40:20 GMT

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