Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

Bar Chart

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

8 Replies
manoranjan_d
Specialist
Specialist
Author

first stack chart show the count of  dept wise

dept wise

below is the data

 

DeptCount
IT100
CSE200
EEE300

second stack bar shows count of male and female

  

PersonCount of Person
Male 1000
Female2000
Not applicable

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.

manoranjan_d
Specialist
Specialist
Author

Capture.PNG

these two stack bar has to be in one chart

manoranjan_d
Specialist
Specialist
Author

not correct answer

prabhu0505
Specialist
Specialist

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.

srchilukoori
Specialist
Specialist

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

MarcoWedel

Hi,

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

QlikCommunity_Thread_188937_Pic1.JPG

QlikCommunity_Thread_188937_Pic2.JPG

hope this helps

regards

Marco