topic Mouse hover in scatter chart in QlikView

Mouse hover in scatter chart

Mon, 11 Jul 2011 14:50:00 GMT

Is it possible to add more details in a scatter chart for mouse hover? please see attached image.. by default, mouse hover shows dimension and expression values. I need to add more details such as average, etc.

Tried with dual function, but that did not work (still shows default values) Can someone provide suggestions please.. thanks!

Re: Mouse hover in scatter chart

rwunderlich — Mon, 11 Jul 2011 21:43:06 GMT

Yes, you can add more details by adding addtional expressions. In a scatter chart, expressions 1 and 2 are the dimensions, expression 3 is the bubble size (if using that style). Expression 4 and subsequent expressions can be used to provide additional lines for the hover popup. Nothing will be plotted in the chart, but the expression value will appear in the popup. Note that the label value from these addtional expressions will not appear in the popup. If you want a "label", you must include it in the expression. Like:

='Net = ' & money(Revenue - COGS)

-Rob

http://robwunderlich.com

Mouse hover in scatter chart

Fri, 25 May 2012 18:57:22 GMT

Rob,

Beautiful! Worked perfectly.

I ended up using 4 expressions:

expr 1: My X-axis
expr 2: My Y-axis
expr 3: the bubble size
expr 4: the label, using the method you describe (i.e. 'Metric = ' & <expression>)

When I included the label in the size expression, it set all the sizes the same. I guess it couldn't interpret the label as a number and gave up...

I guess in theory you could do it as one expression: num(expression, 'Metric = $#,##0.00;Metric = ($#,##0.00)'). Maybe I'll go try that now.