Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

stacked and grouped chart

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

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

Then, Dimension tab :

QV_003.png

and Expressions tab :

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.

0 Replies