Obtaining a chart with clustered stacked columns by month, something as below :
![QV_001.png](/legacyfs/online/103535_QV_001.png)
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
![QV_002.png](/legacyfs/online/103537_QV_002.png)
Then, Dimension tab :
![QV_003.png](/legacyfs/online/103538_QV_003.png)
and Expressions tab :
![QV_004.png](/legacyfs/online/103539_QV_004.png)
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.