topic Stacked bar chart when more than one fields are there in QlikView

Stacked bar chart when more than one fields are there

Fri, 17 Dec 2010 13:50:22 GMT

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)

Stacked bar chart when more than one fields are there

johnw — Sat, 18 Dec 2010 01:04:16 GMT

Maybe this?

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

Stacked bar chart when more than one fields are there

Mon, 20 Dec 2010 07:01:54 GMT

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.