Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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"

View solution in original post

8 Replies
oscar_ortiz
Partner - Specialist
Partner - Specialist

Give something like this a try.

Good Luck

Oscar

Not applicable
Author

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
Author

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
Partner - Specialist
Partner - Specialist

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
Author

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
Author

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
Author

That works! Thank you very much!

Rajiv.

Anonymous
Not applicable
Author

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?