stacked and grouped chart

Anonymous — Thu, 29 Oct 2015 23:43:05 GMT

Obtaining a chart with clustered stacked columns by month, something as below :

For details , I have joined little excel file with random data and qlikview app - made with personal edition

For an overview, I have done in excel

- one sheet for mapping (to group) betwwen "segment" and "groups" (1 segment contains n groups)

- one "sheet" per Sales, Budget and Forecast, with similar crosstab to have "values" by both "group" and "month".

Then, after loaded all that, with "uncross" data, to 3 tables (Sales, Budget, Forecast)I have done a "keyTable" to join them

on "date" and "segment" and added a "noStack" to define associated stack in chart

Then, Dimension tab :

and Expressions tab :

If possible, main point I would like to make "dynamic" is about "measures" because I have done one measure per segment with segment code in the expression of measure.

topic stacked and grouped chart in QlikView

stacked and grouped chart