topic Re: Clustered-Stacked Column and Bar Charts in QlikView in QlikView

Clustered-Stacked Column and Bar Charts in QlikView

Thu, 17 May 2012 14:03:06 GMT

Hi,

I was wondering if anyone would be able to help. Is it possible to create Clustered-Stacked Column & Bar Charts within QlikView?

Examples:

Any help would be greatly appreciated.

Many thanks.

Rajiv.

Re: Clustered-Stacked Column and Bar Charts in QlikView

oscar_ortiz — Thu, 17 May 2012 14:55:07 GMT

Give something like this a try.

Good Luck

Oscar

Re: Clustered-Stacked Column and Bar Charts in QlikView

Thu, 17 May 2012 16:27:35 GMT

Thanks Oscar. I can't seem to open the file as I am running on a Personal Edition.

Is there any coding that you can send across?

Thanks.

Rajiv.

Re: Clustered-Stacked Column and Bar Charts in QlikView

Thu, 17 May 2012 16:27:54 GMT

Thanks Oscar. I can't seem to open the file as I am running on a Personal Edition.

Is there any coding that you can send across?

Thanks.

Rajiv.

Re: Clustered-Stacked Column and Bar Charts in QlikView

oscar_ortiz — Thu, 17 May 2012 17:44:46 GMT

Yep, sorry about that.

This is how I setup my tables:

Data:

LOAD * INLINE [

City, ForecastA, ForecastB, ForecastC, Measurement

Chicago, 5, 7, 7, Forecast

Atlanta, 8, 10, 10, Forecast

Detroit, 7, 9, 9, Forecast

Boston, 3, 5, 5, Forecast

];

LOAD * INLINE [

City, ActualA, ActualB, ActualC, Measurement

Chicago, 6, 8, 4, Actual

Atlanta, 7, 9, 5, Actual

Detroit, 5, 7, 3, Actual

Boston, 4, 6, 2, Actual

];

I've attached screen shots of the chart properties.

Good luck

Re: Clustered-Stacked Column and Bar Charts in QlikView

Fri, 18 May 2012 15:31:59 GMT

Many thanks Oscar. I have managed to produce these graphs in this format now.

Is it possible to add data labels to the graph? For example, it displays values for all the segments in the stacked columns?

Rajiv.

Clustered-Stacked Column and Bar Charts in QlikView

Fri, 18 May 2012 15:49:04 GMT

in case u have not figured it. you need to check "Values on data points" for each of the expression

Then go to the Presentation tab and check "Plot Values inside Segments"

Re: Clustered-Stacked Column and Bar Charts in QlikView

Fri, 18 May 2012 15:52:35 GMT

That works! Thank you very much!

Rajiv.

Re: Clustered-Stacked Column and Bar Charts in QlikView

Anonymous — Tue, 01 Aug 2017 21:01:11 GMT

Would I need to create an identifying field such as your Measurement field to perform this? I currently use other field values in an expression to generate the value(s) I need, however without a way to group these all as a "measurement" I don't see how I could do so.

Would creating an inline table of sorts be the route to go?