Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

Stacked bar chart and "Text on Axis" expression

Dear Community,

I faced a problem with a stacked bar chart.

Type:          Barchart

Dim:           YearMonth (Default)

                  +e.g. Area (conditional, for stacked bar chart)

Expression: 1.Sum(Value) for bar (simplified)

                  2.if statement which used to create a short text on x-axis per month to identify if the value is track,settled or budget type

If I disable the second expression for the "Text on axis" the stacked bar chart works fine but when enable and select e.g. Area as second dimension the bar charts are grouped, not stacked, and for each bar a "Text on Axis" is created.

Is there a possibility to modify the "Text on axis" if statement, that also when a second dimension is selected, a stacked bar chart with only one "Text on Axis" will be displayed?

Every advice is welcome.