Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

renjithpl
Valued Contributor

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
Partner
Partner

Re: Display single total on axis for stacked bar chart

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".
#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.
Highlighted
renjithpl
Valued Contributor

Re: Display single total on axis for stacked bar chart

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

Re: Display single total on axis for stacked bar chart

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

#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.
renjithpl
Valued Contributor

Re: Display single total on axis for stacked bar chart

Thanks. 

I want them displayed on "Text on Axis".