Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mambi
Creator III
Creator III

Total display in Bar Chart

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 ?

8 Replies
avinashelite

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

MK_QSL
MVP
MVP

Try something like this...

mambi
Creator III
Creator III
Author

it's doesn't work

Capture d’écran 2016-06-28 à 14.30.26.png

mambi
Creator III
Creator III
Author

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

MK_QSL
MVP
MVP

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?

mambi
Creator III
Creator III
Author

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

MK_QSL
MVP
MVP

Is this wrong?

Capture.JPG

mambi
Creator III
Creator III
Author

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