topic Re: MULTIPLE STACKED BARS CHART in QlikView

MULTIPLE STACKED BARS CHART

Anonymous — Wed, 20 Mar 2013 09:32:25 GMT

hello everybody.

let's suppose i have two products (A & B), their quantities (Qa & Qb) and the revenues (Ra &Rb); a set of Brands/Companies selling these same two products and data in an interval of 7 months (for example)

i'd like to create a multiple stacked bar chart as attached: on the x-axis months, primary y-axis (left) quantities and secondary y-axis (right) revenues; the Brand/Company should act like a global filter to focus on each single enterprise performance.

could you help me?

Re: MULTIPLE STACKED BARS CHART

Gysbert_Wassenaar — Wed, 20 Mar 2013 10:50:02 GMT

See attached example. It uses a valuelist as calculated dimension. It also uses an expression for setting the colors of the segments. Click on the + in front of the expression and then select Background Color.

Re: MULTIPLE STACKED BARS CHART

Anonymous — Tue, 23 Apr 2013 12:49:40 GMT

thanx. i'v worked around your suggestion... talking about the qvw test file you posted:i'd need to set the yellow/red bars in a different scale, i.e. on a secondary axis (y-axis). bye