topic Re: 3d bar graphs in QlikView

3d bar graphs

Mon, 17 Sep 2012 09:37:10 GMT

Hey guys

is it possible to create 3d bar graphs like the one in the atached file?

I have tried but failed to find a way.

appriciate any help

Re: 3d bar graphs

rajni_batra — Mon, 17 Sep 2012 11:24:12 GMT

yes this is one of the chart style provided in bar graph under style Tab

Did u try that?

Re: 3d bar graphs

MayilVahanan — Mon, 17 Sep 2012 13:36:28 GMT

In bar chart -> properties-> style-> Look fifth or sixth option help you to achieve this..

Re: 3d bar graphs

Tue, 18 Sep 2012 13:23:53 GMT

I have tried the properties in the bar chart option but it doesnt allow me to do that.

This is how I have arranged my data in the table.

All I can do is present as shown in the attachment.

Really I want to present a format shown in my original post

PersonsNo	A1	A2	A3
Person1	12%	40%	79%
Person2	14%	21%	77%
Person3	12%	29%	75%
Person4	13%	28%	72%
Person5	8%	19%	65%
Person6	8%	11%	64%
Person7	8%	20%	61%
Person8	12%	14%	60%
Person9	11%	15%	49%
Person10	6%	8%	43%
Person11	6%	8%	36%
Person12	4%	5%	35%
Person13	7%	7%	32%
Person14	5%	4%	30%
Person15	5%	3%	28%

Re: 3d bar graphs

whiteline — Tue, 18 Sep 2012 13:34:58 GMT

You should have at least 2 dimensions.

While in your data there is only one (PersonsNo).

Transform it, so that the An become a dimension.

Re: 3d bar graphs

Tue, 18 Sep 2012 14:13:37 GMT

When I convert it so An become the dimension then I have no expression to calculate/display.

I simply transformed my table as follows.

Still no joy. What would be the proper way?

An	Person1	Person2	Person3	Person4	Person5
A1	12%	14%	12%	13%	8%
A2	40%	21%	29%	28%	19%
A3	79%	77%	75%	72%	65%

Re: 3d bar graphs

MayilVahanan — Tue, 18 Sep 2012 14:29:30 GMT

Do you want something like attached file?

Re: 3d bar graphs

Tue, 18 Sep 2012 14:40:28 GMT

unfortunately i cant open any external QV files because I am using the personal edition.

can you post a pic please?

Re: 3d bar graphs

MayilVahanan — Tue, 18 Sep 2012 14:48:22 GMT

Please check the attached image

Re: 3d bar graphs

Tue, 18 Sep 2012 14:52:01 GMT

Thanks for the post.

Unfortunately that is not what I want. What I want is attached like this

Re: 3d bar graphs

Anonymous — Tue, 18 Sep 2012 16:03:56 GMT

Here is the option you need. I would recommend not using this type of representation if you can help it though because it is hard to compare the values. For example in your pic above, you can't tell what the value for Tom/East is.

Re: 3d bar graphs

Tue, 18 Sep 2012 16:14:46 GMT

when I try that I get the following chart.

This is very weird because the chart is stacked but you can see the West, East, North and South (circled) with no values.

Re: 3d bar graphs

Anonymous — Tue, 18 Sep 2012 16:20:10 GMT

Yeah, thats a little strange. Is either the name or the direction set up as an expression? Because you will only get the proper rendering with two dimensions and one expression.

Re: 3d bar graphs

Tue, 18 Sep 2012 16:34:18 GMT

this is my table that I am using to produce the above chart.

	North	South	East	West
Tom	13	23	54	14
Dick	10	11	85	54
Harry	15	41	55	6
Peter	12	14	45	47

Re: 3d bar graphs

whiteline — Tue, 18 Sep 2012 16:49:18 GMT

As I said earlier, the problem is that you use one dimension and three expressions, while you should use 2 dimensions and one expression.

Convert your data in a form:

An Personn Percent

A1 Person1 12%

...

Then use first two as a dimension and Percent as an expression.

Re: 3d bar graphs

Anonymous — Tue, 18 Sep 2012 16:50:06 GMT

OK, so you need to crosstable that data so that your table looks more like below. Your values should be in a single column so that way you only need one expression to report on them. I have attached the qvw as example. Hopefully that makes sense.

Name	Region	Value
Dick	East	85
Dick	North	10
Dick	South	11
Dick	West	54
Harry	East	55
Harry	North	15
Harry	South	41
Harry	West	6
Peter	East	45
Peter	North	12
Peter	South	14
Peter	West	47
Tom	East	54
Tom	North	13
Tom	South	23
Tom	West	14

Re: 3d bar graphs

MayilVahanan — Tue, 18 Sep 2012 16:57:20 GMT

Try like this,

Dimension: Name and ValueList('North','South','West','East')

Exp:

If(ValueList('North','South','West','East')='North',Sum(North),if(ValueList('North','South','West','East')='South',Sum(South),

if(ValueList('North','South','West','East')='West',Sum(West),Sum(East))))

Hope it helps

Re: 3d bar graphs

Wed, 19 Sep 2012 09:28:58 GMT

thanks alot guys.

you've given 2 solutions here.

One is to transform the data as shown in Aaron's post.

Second option is to use Mayil's Valuelist with the if expressions above.

I think the better way for me to go about this is to use Mayil's method because then wouldn't have to transform the data.

thanks guys.

Re: 3d bar graphs

whiteline — Wed, 19 Sep 2012 09:49:24 GMT

In some cases it's useful to have both representations of data.

Just add East, North, South, West fields to Aaron's table with corresponding values (skipping other region rows with nulls).

In this case you'll have a choice of what approach to use in a particular Chart or Expression.