Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Actully i tried it by many way.
but whenever i tried it. it shows 400%
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%