Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Clustered-Stacked Column and Bar Charts in QlikView

Hi,

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

Examples:

Clustered-Stacked Column Chart   Clustered-Stacked Bar Chart

Any help would be greatly appreciated.

Many thanks.

Rajiv.

1 Solution

Accepted Solutions
Not applicable

Clustered-Stacked Column and Bar Charts in QlikView

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"

8 Replies
oscar_ortiz
Valued Contributor

Re: Clustered-Stacked Column and Bar Charts in QlikView

Give something like this a try.

Good Luck

Oscar

Not applicable

Re: Clustered-Stacked Column and Bar Charts in QlikView

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.

Not applicable

Re: Clustered-Stacked Column and Bar Charts in QlikView

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.

oscar_ortiz
Valued Contributor

Re: Clustered-Stacked Column and Bar Charts in QlikView

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

Not applicable

Re: Clustered-Stacked Column and Bar Charts in QlikView

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.

Not applicable

Clustered-Stacked Column and Bar Charts in QlikView

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"

Not applicable

Re: Clustered-Stacked Column and Bar Charts in QlikView

That works! Thank you very much!

Rajiv.

cwagner_wr
New Contributor III

Re: Clustered-Stacked Column and Bar Charts in QlikView

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?