Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
BoXiangWang
Contributor II
Contributor II

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
Creator III
Creator III

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