topic Re: Representing a nested stacked bar chart in QlikView

Representing a nested stacked bar chart

Wed, 18 Jun 2014 00:06:48 GMT

I'm a QlikView beginner and I'm working with a piece of data; trying to visualize it as a bar chart.

More specifically, I need to develop a nested stacked bar chart as shown in the image. At a top level, for every project, I need to have the length of the stacks of the bar chart proportional to "TotalUpdates" for the 5 different project locations. (Loc 1 to Loc 5)

At a second level, within each one of the stacks that I described above, I need to be able to represent the percentage of completion. Which is UpdatesCompleted/TotalUpdates. (Shaded or colored differently)

I tried using the crosstable, but it did not work. Since I'm trying to work with three dimensions, I'm unable to find a suitable solution to handle this. The input spreadsheet and a snapshot of the desired representation is attached.

Re: Representing a nested stacked bar chart

SergeyMak — Wed, 18 Jun 2014 00:53:07 GMT

Hi,

I don't understand your sorting of Loc

Why the order is Loc 5, Loc 4, Loc 1, Loc 2, Loc 3

Is it always or are there some hidden rules?

Regards,

Sergey

Re: Representing a nested stacked bar chart

SergeyMak — Wed, 18 Jun 2014 01:58:52 GMT

PFA an example

Regards,

Sergey

Re: Representing a nested stacked bar chart

Thu, 19 Jun 2014 16:22:13 GMT

Thank you very much Sergey! Works like a charm 🙂