Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Request you to create some dummy data and post sample qvw to help you.
Vikas
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.
Hi,
I didn't understand your requirement.
Could you explaint little more?
From where you want to pick "Inv 2013" and "Ownershipt 2013".?
Karthik
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:
Hope this might help you please see the sample.
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?
Genie i dont think that logically this is right .
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
can you post a sample of just 5 opr 10 ecords ...
just create it with INLINE code
...