topic Re: Stacked & Grouped Bar Chart in QlikView

Stacked & Grouped Bar Chart

Thu, 18 May 2017 08:53:56 GMT

I have a grouped bar chart with a target line at 100%. I want the area between the target line and the bar value to be filled by a bar in red(kind of like a stacked bar with 100% - bar value in red). Any ideas on how this might be possible?

Re: Stacked & Grouped Bar Chart

hector_munoz — Thu, 18 May 2017 09:14:24 GMT

Hi Ramedh,

You could create an extra expression with a formula such as: 1 - (exp1+exp2+exp3).

Regards,
Héctor

Re: Stacked & Grouped Bar Chart

Frank_Hartmann — Thu, 18 May 2017 09:17:00 GMT

I think you can either group or stack a barchart,

but both at the same time might be not possible.

I think you could use an Offset to show the difference between 100 and the existing value!

have alook at the attached sample

Re: Stacked & Grouped Bar Chart

prieper — Thu, 18 May 2017 09:19:54 GMT

something like the attached?

pfa