100% Stack Bar Chart

[#1]

Hi Community,

I do not see an option for a 100% Stacked Bar Chart. Does anyone have a workaround for this?

dimension=

1)branch_type

2)( i added following range of param_value as Calculated dimension)

if(match(branch_type,'FACTORY','PT','DEPOT','ST','Snowman'),

if(param_name='TEMP' and (param_value)<='-1' and (param_value)>= '-10', '1',

if(param_name='TEMP' and (param_value)<= '-10.1' and (param_value)>='-13.9', '2',

if(param_name='TEMP' and (param_value)<= '-14' and (param_value)>='-17.9', '3',

if(param_name='TEMP' and (param_value)<= '-18' and (param_value)>='-19.9', ' ',

if(param_name='TEMP' and (param_value)<= '-20', '4'))))),

if(match(branch_type,'RSV','RS Cold Room'),

if(param_name='TEMP' and (param_value)<='-1' and (param_value)>= '-10', '1',

if(param_name='TEMP' and (param_value)<= '-10.1' and (param_value)>='-13.9', '2',

if(param_name='TEMP' and (param_value)<= '-14' and (param_value)>='-17.9', '3',

if(param_name='TEMP' and (param_value)<= '-18', ' 4'))))))

Expression -

Count({$<param_name={'TEMP'},param_value={'-1'}>}param_value)/

Count(total<branch_type>{<param_name={'TEMP'},param_value={'-1'}>}param_value)

It gives 400% Stack bar graph which is not correct.

Thanks

[datanibbler]

Hi Tushar,

I have recently found some limits of the stacking thing in barcharts. I haven't noticed anything about the %, but I don't have that in my chart.

Have you checked if maybe QlikView calculates the percentage of all the segments of one column so that these summed up return 100%? That would be thinkable.

[awhitfield]

Hi Tushar,

check out the attached link:

https://community.qlik.com/thread/13284

HTH - Andy

[#4]

Actully i tried it by many way.

but whenever i tried it. it shows 400%

[#5]

Same here. when i used

Count({$<param_name={'TEMP'},param_value={'-1'}>}param_value)/

Count(total<branch_type>{<param_name={'TEMP'},param_value={'-1'}>}param_value)

this Expression and above Calculated dimension.

it shows 400%