relative to total in a bar chart

[ilanbaruch]

hi all

in my model i have a stacked bar chart with calculated dim as below :

1. calculated dim :

=if( aggr( NODISTINCT rank( sum({<In_Out={'Out'},REPORT_NAME={'(BL)'}
,YearQuarter_NUM={"<=$(=(vNumMaxQ)) >=$(=(vNumMaxQ_L8))"},Year=,Quarter=
>} REV) ),YearQuarter, PRIMARY_NAME) <=5 , PRIMARY_NAME)

2. YearQuarter

i want to calculate the relative share of every PRIMARY_NAME within the  Quarter i.e :

for Q3\17 : 17%, 10%, 46%,6%,20% - the total for Q3\17 would be 100%

any ideas ?

advanced thanks

[Claudiu_Anghelescu]

https://community.qlik.com/t5/QlikView-Documents/QlikView-Create-100-Full-Stacked-Bar/ta-p/1545504