Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stacked bar chart when more than one fields are there

Hi

Imagine "Team" is a field and Less than 6,Above 5 below 20 and Above 20 is also field in a table. I would like a do the following in a bar chart. I am finding it very difficult Less than 6,Above 5 below 20 and Above 20 is a seperate field(Column) how can I bring that in a stack. That is my question?

Hope some might have come across same kind of requirement. Hope they can help me out

Requirement:

Team = QlikView, Less than 6 = 5, Above 5 below 20 = 5, Above 20 = 5

What I would like to display, is a bar chart, by team, but shows a stacked column with sub divisions of less than 6, above 5 below 20, and above 20

Effectively, for the line above, it would show a single bar column for Homeworking with 3 x 1/3 segments (each representing the value of 5)

Need some thing like below one: (See the comment in the screen shot)

error loading image

2 Replies
johnw
Champion III
Champion III

Maybe this?

Dimension = Team
Expression 1 = Less than 6
Expresison 2 = Above 5 below 20
Expression 3 = Above 20
Style Subtype = Stacked

Not applicable
Author

Yes John you are right! I have already did that forgot to inform that in the post. It was simple but not straight forward. 🙂 Many thanks for your help.