topic Re: Total display in Bar Chart in QlikView

Total display in Bar Chart

mambi — Tue, 28 Jun 2016 12:57:06 GMT

Hello everyone,

i'm using QV 8.5 and i want to display my bar chart as the image below ;

my expression is sum(QTE) / sum(total <CAT, YEAR> QTE) ( to display the percentage inside each segment )

All i want to do is to display the total (not in percentage) next to each bar ( for exemple : 2016 -> category 1 the sum of all quantities is 125....)

here's the data :

LOAD * INLINE [
     CAT, PROD, QTE, YEAR
     category 1, prod 1, 10, 2015
     category 1, prod 1, 34, 2016
     category 1, prod 2, 20, 2015
     category 1, prod 2, 59, 2016
     category 1, prod 3, 32, 2016
     category 1, prod 3, 70, 2015
     category 2, prod 1, 11, 2016
     category 2, prod 1, 30, 2015
     category 2, prod 2, 15, 2016
     category 2, prod 2, 30, 2015
];

i know that's in QV11 there's the option "still show the total on top" but it's display 100% and it's not available in QV 8.5

any idea how to achieve this task ?

Re: Total display in Bar Chart

avinashelite — Tue, 28 Jun 2016 13:01:51 GMT

add one more expression like this

sum(QTE) without set analysis and un-check the bar , check show values on data points that would server your requirement

Re: Total display in Bar Chart

MK_QSL — Tue, 28 Jun 2016 13:21:15 GMT

Try something like this...

Re: Total display in Bar Chart

mambi — Tue, 28 Jun 2016 13:39:14 GMT

it's doesn't work

Re: Total display in Bar Chart

mambi — Tue, 28 Jun 2016 13:57:55 GMT

Sorry, it's doesn't work on QV 8.5

Re: Total display in Bar Chart

MK_QSL — Tue, 28 Jun 2016 14:00:34 GMT

Sorry I don't have 8.5 version, so can't test on it...

Just for my curiosity... why don't you change to latest version?

Re: Total display in Bar Chart

mambi — Tue, 28 Jun 2016 14:00:39 GMT

even the option : Text on axis displays numbers in a wrong way !

Re: Total display in Bar Chart

MK_QSL — Tue, 28 Jun 2016 14:03:30 GMT

Is this wrong?

Re: Total display in Bar Chart

mambi — Tue, 28 Jun 2016 14:06:42 GMT

because my client has a license for this version (QV desktop 8.5)