Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

3d bar graphs

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

1 Solution

Accepted Solutions
MayilVahanan

Hi

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

18 Replies
rajni_batra
Specialist
Specialist

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

Did u try that?

MayilVahanan

Hi

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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

PersonsNoA1A2A3
Person112%40%79%
Person214%21%77%
Person312%29%75%
Person413%28%72%
Person58%19%65%
Person68%11%64%
Person78%20%61%
Person812%14%60%
Person911%15%49%
Person106%8%43%
Person116%8%36%
Person124%5%35%
Person137%7%32%
Person145%4%30%
Person155%3%28%

barChart_1.bmp

whiteline
Master II
Master II

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.

Not applicable
Author

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?

AnPerson1Person2Person3Person4Person5
A112%14%12%13%8%
A240%21%29%28%19%
A379%77%75%72%65%
MayilVahanan

hi

  Do you want something like attached file?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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

can you post a pic please?

MayilVahanan

Hi

Please check the attached image

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thanks for the post.

Unfortunately that is not what I want. What I want is attached like this3dbar_labels2.png