Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
Try something like this...
it's doesn't work
Sorry, it's doesn't work on QV 8.5
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?
even the option : Text on axis displays numbers in a wrong way !
Is this wrong?
because my client has a license for this version (QV desktop 8.5)