QlikView App Dev

[#1]

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.

[oscar_ortiz]

Give something like this a try.

Good Luck

Oscar

[#3]

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.

[#4]

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]

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

[#6]

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.

[#7 · Accepted solution]

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]

That works! Thank you very much!

Rajiv.

[Anonymous]

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?