topic Re: Block chart with legends in QlikView

Block chart with legends

Anonymous — Thu, 21 Feb 2013 15:24:53 GMT

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

Re: Block chart with legends

Thu, 21 Feb 2013 17:10:38 GMT

To my knowledge there isn't an easy way, but you can kind of fake it. See attached.

Re: Block chart with legends

Anonymous — Thu, 21 Feb 2013 19:33:44 GMT

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

Re: Block chart with legends

Thu, 21 Feb 2013 20:01:20 GMT

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.

Re: Block chart with legends

Tue, 05 Mar 2013 19:45:04 GMT

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