topic 100% Stack Bar Chart in QlikView

100% Stack Bar Chart

Mon, 27 Jul 2015 07:42:52 GMT

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

Re: 100% Stack Bar Chart

datanibbler — Mon, 27 Jul 2015 08:26:28 GMT

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.

Re: 100% Stack Bar Chart

awhitfield — Mon, 27 Jul 2015 08:29:12 GMT

Hi Tushar,

check out the attached link:

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

HTH - Andy

Re: 100% Stack Bar Chart

Mon, 27 Jul 2015 10:02:59 GMT

Actully i tried it by many way.

but whenever i tried it. it shows 400%

Re: 100% Stack Bar Chart

Mon, 27 Jul 2015 10:04:59 GMT

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%