topic Re: Bar Chart in QlikView

Bar Chart

manoranjan_d — Fri, 23 Oct 2015 19:31:20 GMT

Hi all,

I m using two stack bar chart.

1 stack bar chart and 2 stack bar chart: have different dimension and expression

Now i want to these two stack bar chart has to be in one bar chart and they should show the two different stack bar

Re: Bar Chart

prabhu0505 — Fri, 23 Oct 2015 19:40:47 GMT

https://community.qlik.com/docs/DOC-2380#comment-3393

Re: Bar Chart

manoranjan_d — Fri, 23 Oct 2015 19:40:58 GMT

first stack chart show the count of dept wise

dept wise

below is the data

Dept	Count
IT	100
CSE	200
EEE	300

second stack bar shows count of male and female

Person	Count of Person
Male	1000
Female	2000

Re: Bar Chart

Fri, 23 Oct 2015 19:42:02 GMT

Hello - I would recommend that you keep the two charts separate, as they represent different dimensions and expressions.

You might consider placing them in a container object with "Grid" Style selected on the presentations tab.. This way you can visualize each side-by-side and with similar sizing.

Re: Bar Chart

manoranjan_d — Fri, 23 Oct 2015 19:43:20 GMT

these two stack bar has to be in one chart

Re: Bar Chart

manoranjan_d — Fri, 23 Oct 2015 19:44:25 GMT

not correct answer

Re: Bar Chart

prabhu0505 — Fri, 23 Oct 2015 19:51:16 GMT

My previous reply was not answer, it was just to tell the details provided by you are not clear.

That's fine. Let's circle back to your question.

You can create cyclic dimension group and based on the active field in cyclic group you can change the expression.

Same object for two different sets of Dimension and Metric.

Re: Bar Chart

srchilukoori — Fri, 23 Oct 2015 20:38:28 GMT

It might work if you transform the tables in the attached format, but with some trade offs.

Re: Bar Chart

MarcoWedel — Sat, 24 Oct 2015 00:17:13 GMT

Hi,

not very nice, but seems to work (sort of) without changing your data model:

hope this helps

regards

Marco