topic Re: BAR CHART LEGEND POP UP in QlikView

BAR CHART LEGEND POP UP

Mon, 04 Aug 2014 14:11:32 GMT

The attached Bar Chart is using Question as Legend. When I Hover over the Question Legend I should be able to see the Whole quetsion. BUt its not happening. Is there an option to see the whole text in the Legend when Hoverered Over.

Plese Help

Re: BAR CHART LEGEND POP UP

Mon, 04 Aug 2014 14:15:33 GMT

Hi,

There is an option to use text as pop-up under the expresion tab. Does that solve your problem?

Re: BAR CHART LEGEND POP UP

Mon, 04 Aug 2014 14:18:25 GMT

NO cuz that works for Expression ONly as Pop UP. I am trying to achieve is if USER Hover Over the Legend (Question) in this case should be able to see the whole Question

Re: BAR CHART LEGEND POP UP

Mon, 04 Aug 2014 14:27:02 GMT

You can have the question dimension as an expression as well. And then untick the bar box under "display options" in the "expression tab". Was that understandable?

Re: BAR CHART LEGEND POP UP

Mon, 04 Aug 2014 14:30:19 GMT

That doesnt work, If I remove it as a Dimension I dont get Any Legend??

Re: BAR CHART LEGEND POP UP

Anonymous — Mon, 04 Aug 2014 14:46:23 GMT

Jon is suggesting not removing Question from dimension. Leave it in dimension since you need the legend. Additionally, add Question as an expression and uncheck the bar option in display options for this expression.

another work around is a) do not display legend from your bar chart. b) clone the bar chart and make the new bar chart a straight table. then hide all the columns except Question. in dimension, check show all values and make the table read only if you have to and place it right where the original legend is located.

Re: BAR CHART LEGEND POP UP

Mon, 04 Aug 2014 15:10:19 GMT

I dont wanna clone it cuz then I wont be able to see teh Color Boxes corresponding to each Legend

Re: BAR CHART LEGEND POP UP

tobias_klett — Mon, 04 Aug 2014 15:18:10 GMT

Hi Ray,

try using the dual Function and add everything you want to read in the text-part and the expression as it is in the number-part. Make sure on Numbers-Tab you are on expression default and format your number in the text-part.

dual( Dimensionfield & ' ' & num(sum(XY),'#,##0') , sum(XY) )

Hope this helps

Re: BAR CHART LEGEND POP UP

Mon, 04 Aug 2014 15:47:58 GMT

Doesn't Work

Re: BAR CHART LEGEND POP UP

tobias_klett — Mon, 04 Aug 2014 16:07:52 GMT

did you put your the dual around your expression like that?
dual( dimensionfield & expression, expression)
Did you switch to the numbers-tab and make sure this expression is on default?

Re: BAR CHART LEGEND POP UP

Mon, 04 Aug 2014 16:30:16 GMT

Yes exactly as u said

Re: BAR CHART LEGEND POP UP

Anonymous — Mon, 04 Aug 2014 17:14:37 GMT

may be a sample qvw will help address your problem. but there are only so many ways you can make the legend look...you will need a work around.

Re: BAR CHART LEGEND POP UP

tobias_klett — Mon, 04 Aug 2014 17:44:13 GMT

could you add your qvw on this post?