Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need to create a bar chart as below, has anyone done it before? any advise?
- i have a top 20 list - field = top_list dimension & 1 rating (low, medium, high) dimension
- 1 expression, count(record_number)
- each of the bar must up to 100%
- the low medium high segment short and long , depends on the count of record number.
Rgds
Jim
see attached
There is no native QV Option to show absolute numbers within a percentage axis! Thats why you need to create an extra transparent chart with invisible expressions and overlay this to the existing chart!
See attached file for workaround!
hope this helps
i saw your qvw file. u r using expression:
(count({<Rating={'HIGH'}>}Category))/count(Category)
y cannot (count({<Rating={'HIGH'}>}Category))/count( TOTAL Category)
???
that was just to get the proportions and the percentage axis for the transparent chart.
Perhaps the attached solution might be better but the probleme will be to fit the absolute numbers to the
corresponding bar. perhaps someone has a better solution....
USE a DUAL expression, there is no need to overlay a transparent chart
can you post a data sample to demonstrate
see attached