Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
BoXiangWang
Contributor III
Contributor III

Add Alternative Dimension in a Stacked Bar Chart

Hello QS experts,

I am dealing with a bar chart. Here is the outcome when I only select March 2024.

BoXiangWang_0-1711619802777.png

I'd like to add an Alternative Dimension, which is the autocalendar.YearMonth.

After adding the dimension, it seems that it couldn't fit with my current measure expression.

The accumulation should be 359, but it shows 16 instead.

BoXiangWang_1-1711619923028.png

Is there any way add another expression to fit with the dynamic dimension?

The expressions I am using are:

Measure: 

=
Aggr(
Count({<Date={"<=$(=Today())"} >} ID),
Class , (Date,NUMERIC,ASCENDING)
)

Dimension:

Date, Class

Labels (3)
1 Reply
Clement15
Partner - Specialist
Partner - Specialist

Hello, do you have an example of data for testing?