Stacked Bar Chart

[#1]

Hi,

I have the following field data that load from excel:

Initiative Category, Project Status, Opex Total

I want to display the data in a stacked bar chart as something like the following:

1. Y axis as the sum of opex total

2. X axis to create a group "Opex FY13" that contains all the Initiative Category and Project Status

3. Legends that display different colors for Intiative Category and Project Status

How should I construct the script and create the bar chart?

Thank you

[vikasmahajan]

Request you to create some dummy data and post sample qvw to help you.

Vikas

[#3]

Hi,

I've attached sample data and the output of the barchart.

Currently i'm still using Personal Edition and have used up all my recovery quota.

Please take screen shot of the dimension and expresion. Thanks a lot.

[#4]

Hi,

I didn't understand your requirement.

Could you explaint little more?

From where you want to pick "Inv 2013" and "Ownershipt 2013".?

Karthik

[#5]

Inv 2013 = Sum of Capex and Opex

Ownership 2013 = Sum of Ownership

Currently, in my Dimension, i've place "T&O Functional Unit" and "Project Status".
Then in i have 2 expression, "Sum(Capex + Opex)" and "Sum(Onwership)".

But that's not the result i wan. I want the Legend on the right as "Business Case Preparation, Completed, In Progress...". Then for the X axis, i want to create 2 new label, "Inv 2013" for the Capex + Opex and "Ownership" for the ownership sum.

So this should be the result that i want:

[sujeetsingh]

Hope this might help you please see the sample.

[#7]

Sorry, that sample is not the result i want. What i want is the Legend as the City and the Exp1, Exp2 and Exp3 as Dimension label.

Or how do I tranpose the chart?

[sujeetsingh]

Genie i dont think that logically this is right .

[#9]

i understand it's not the normal way to create bar chart. but this was the requirement from my user. so hoping someone can help me with this as i'm new to qlikview.

maybe probably i have to do some crosstable or pivoting in the script? i'm not really very sure

[sujeetsingh]

can you post a sample of just 5 opr 10 ecords ...

just create it with INLINE code

...