Stacked bar chart in straight table

[yoganantha321]

Hi all,

I have a data source as given excel. I have the output in the straight table with budget in linear chart and  Status in traffic light chart.

My actual output must be like another column with YTD with sum of the budgets in bar chart or linear chart with segments as shown in the straightable_YTD_expected image.

Any body can help me in this?

Thanks,

Yoganantha Prakash G P

[Or]

As far as I know, this is not supported in any way in QlikView. You can simulate a single bar in a QV table by using the Gauge option, and you could probably use the same approach for a static stacked chart (where the switch points are always the same), but this wouldn't work for dynamic stacked charts.

If there's a relatively small number of options for how the chart might look/stack, you might be able to work around this by using pre-built images, but I doubt this is the case here.