topic Re: Stacked Bar Chart in QlikView

Stacked Bar Chart

Mon, 17 Jun 2013 02:53:36 GMT

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

Re: Stacked Bar Chart

vikasmahajan — Mon, 17 Jun 2013 05:05:47 GMT

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

Vikas

Re: Stacked Bar Chart

Mon, 17 Jun 2013 06:02:36 GMT

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.

Re: Stacked Bar Chart

Mon, 17 Jun 2013 08:59:09 GMT

Hi,

I didn't understand your requirement.

Could you explaint little more?

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

Karthik

Re: Stacked Bar Chart

Mon, 17 Jun 2013 09:12:26 GMT

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:

Re: Stacked Bar Chart

sujeetsingh — Mon, 17 Jun 2013 09:33:20 GMT

Hope this might help you please see the sample.

Re: Stacked Bar Chart

Mon, 17 Jun 2013 09:39:27 GMT

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?

Re: Stacked Bar Chart

sujeetsingh — Mon, 17 Jun 2013 09:43:53 GMT

Genie i dont think that logically this is right .

Re: Stacked Bar Chart

Mon, 17 Jun 2013 09:56:45 GMT

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

Re: Stacked Bar Chart

sujeetsingh — Mon, 17 Jun 2013 10:02:25 GMT

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

just create it with INLINE code

...

Re: Stacked Bar Chart

Mon, 17 Jun 2013 10:10:46 GMT

LOAD * INLINE [

Initiative Category, Project Status, T&O Functional Unit, Capex, Opex, Ownership

BU Funded Initiative, In Progress, IBG Tech, 20, 45, 23

Technology and Operations Funded Initiative, In Progress, IBG Tech, 20, 26, 52

EOS Initiative, In Progress, IBG Tech, 40, 25, 63

BU Funded Initiative, Cancelled, TMPB Tech, 30, 32, 13

EOS Initiative, Completed, TMPB Tech, 50, 62, 42

];

Re: Stacked Bar Chart

sujeetsingh — Mon, 17 Jun 2013 11:00:45 GMT

Hi please refer to this sample here i have used the set analysis concept .

Please clarify the dimention i used in my chart .i have takent it according to me you can take what you want .

Hope it help!!

Re: Stacked Bar Chart

Tue, 18 Jun 2013 02:05:47 GMT

ok thanks. it seems like there is no way to create a new dimension on the fly.