Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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