Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
renjithpl
Specialist
Specialist

Display single total on axis for stacked bar chart

Hi All, 

I have two dimensions, one as week, second as Name for a stacked bar chart. 

I have one expression = count (distinct ID) 

I want to display total of the count on axis. 

I am getting multiple totals as its stacked. 

Is there a way to get one single total of all the count 

 

4 Replies
Vegar
MVP
MVP

For existing expression disable "value on axis" and "value on days point". Add a new expression to your chart, with your desired expression, in the display options uncheck "bar" and check "values on data points".
renjithpl
Specialist
Specialist
Author

I want the "overall total" for that particular week on the axis.
Vegar
MVP
MVP

See attached picture. Where I have Date and Material as dimension and my expression is Sum([Stock-level]).

To get the grand total you need to add total <Date> to the new expression, Sum(TOTAL<Date>[Stock-level]). This will result in grand total per date (in your case week).

image.png

renjithpl
Specialist
Specialist
Author

Thanks. 

I want them displayed on "Text on Axis".