topic Re: Display single total on axis for stacked bar chart in QlikView

Display single total on axis for stacked bar chart

renjithpl — Tue, 05 Feb 2019 09:12:14 GMT

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

Re: Display single total on axis for stacked bar chart

Vegar — Tue, 05 Feb 2019 09:24:10 GMT

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".

Re: Display single total on axis for stacked bar chart

renjithpl — Tue, 05 Feb 2019 10:28:14 GMT

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

Re: Display single total on axis for stacked bar chart

Vegar — Tue, 05 Feb 2019 11:10:24 GMT

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).

Re: Display single total on axis for stacked bar chart

renjithpl — Tue, 05 Feb 2019 13:52:12 GMT

Thanks.

I want them displayed on "Text on Axis".