Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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".
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
renjithpl
Specialist
Specialist
Author

Thanks. 

I want them displayed on "Text on Axis".