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: 
Anonymous
Not applicable

Two dimensions, two expressions, stacked bar and line chart?

Dear community,

I have a combo chart with two dimensions, Month and Sub-WorkCentre.

The first of my expressions is a stacked bar chart which simply sums the output Hours per Sub-WorkCentre.

In my second expression I want to show a total capacity line for Main-WorkCentre. We only record capacity at the Main level, the expression is below:

sum(TOTAL <Week> {<Activity={'Capacity'}>} Hours)

However when I try to apply this my stacked bar chart turns to a grouped bar chart with the total capacity line.

Is there a way to get my first expression to stack?

Thanks,

Keith

7 Replies
Anil_Babu_Samineni

Can you show image which currently having?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Hi Anil,

My chart has gone from this:

Chart1.JPG

To this once I introduce the capacity line:

Chart2.JPG

I would like to keep the bars stacked and show the total line running across.

Thanks,

Keith

lorenzoconforti
Specialist II
Specialist II

After changing to "Combo chart", are you selection "Stacked" from the "Style"tab?

Anil_Babu_Samineni

The idea is here Exclude Zero bars

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Hi Anil,

I don't have an issue with the zero/null bar. The question is why the bar chart has moved from stacked to grouped. Apologies if I am missing something from the link you posted above.

Thanks,

Keith

Anonymous
Not applicable
Author

Thanks Sunny. Marked as answered now.

Sunny, sorry to ask but I also posted the question below yesterday.

I recall reading a thread posted by someone else with a similar issue which you answered.... but I can't seem to find it. If not too much trouble would you mind having a look at my thread? Many thanks again, Keith

Two dimensions, two expressions, stacked bar and line chart?

Anil_Babu_Samineni

May be share sample that case, Because i don't have any thing issue using Combo chart?

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)