topic Re: How do I un-stack a 3D bar chart? in QlikView

How do I un-stack a 3D bar chart?

leale1997 — Wed, 25 Nov 2020 16:16:04 GMT

The picture on the left is what I have in QlikView. The picture on the right is what I have in Excel. How can I make the picture on the left look like the picture on the right? QV file is attached.

Re: How do I un-stack a 3D bar chart?

BalaBhaskar_Qlik — Wed, 04 Jul 2018 07:24:28 GMT

Think so, Stacked bar charts can be created in two ways:

1. Two Dimensions, one Measure.

2. One Dimension, multiple Measures.

In order to create the chart in the first case, you need to load your data using the CROSSTABLE load. This way, your Field1, Field2, Field3 labels get loaded as values of an "Attribute Field" and your numeric totals get loaded as the "Data Field". The sum(Data Field) can serve as your Measure.

Otherwise, you can create a stacked bar chart with multiple measures:

sum(Field1)

sum(Field2), etc...

then, you don't have to do anything with your data structure.

Otherwise, created a flag to differentiate between some fields

It has been used in as a secondary dimensionin the bar chart.

And also check this link:

https://community.qlik.com/message/150787#150787

Re: How do I un-stack a 3D bar chart?

jyothish8807 — Wed, 04 Jul 2018 07:58:59 GMT

May be like this:

Br,

Re: How do I un-stack a 3D bar chart?

leale1997 — Fri, 06 Jul 2018 14:23:01 GMT

Thanks so much. This worked perfectly. And I just learned how to add a cross table.

Who knew??

Re: How do I un-stack a 3D bar chart?

leale1997 — Fri, 06 Jul 2018 16:37:14 GMT

Can i ask one more question? I am trying to add variables to the crosstab. This is what my two tables look like now. I would like the crosstab to sort by all the applicable fields.