Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have a requriement to display block chart with legeds aong with the percentages. attached the chart. I am not able to find any speciifc setting which does this in QV. Please help me finding mentioned settings.
Thanks
Dasu.G
To my knowledge there isn't an easy way, but you can kind of fake it. See attached.
Rebecca,
Thanks for the solution. first option we can't use becuase we want to use drill down further atleast
4 levels. Second options is viable option. can you help us understanding second one...
Thanks
Dasu.G
It is a mix of two charts. The first is a stacked bar graph with two dimensions:
1. =" "
2. Product Vehicle
The expression is the percentage calculation you use to get % of Firm AUM by Product Vehicle.
Hide the Y-Axis under Presentation > Axes > Hide Axis and shrink the bar until it is as skinny as you want it by resizing the graph and also by using CTRL + SHIFT. You will also want to disable the legend.
For the legend, I used a pie chart with the dimension Product Vehicle and the expression the same as above. Add the percentages into the legend by using Presentation > Show Numbers in Legend and then hide the pie by using CTRL + SHIFT and dragging it away. Click and drag to resize and then make sure you set the Orders of the two graphs so the bar doesn't cover up the legend when you click on it.
Hope that helps a bit.
Hi Rebecca,
I have been trying to use this solution. For me the second solution works well, but there is a problem. I want to have the legends appear horizontally there as well. Right the the legends in pie chart are vertical, like a list. Is that doable. Would be very helpful to get your insight there. Else I may have to change the design.
Thanks
Raghu