Displaying a color expression value on scatter chart

Mon, 24 Nov 2014 22:48:51 GMT

Hi. I have a scatter chart that uses the required expressions for the x and y axes, I also use a third expression to determine the size of the bubbles. When I hover over a bubble all three of these values display just fine.

But I have a fourth expression that I used to determine the color of each bubble. I can't seem to find a way to get the value of this expression to display when I hover over a bubble.

The expression for the horizontal axis gives me the average list price of an item.

The expression for the vertical axis gives me the average revenue received from a sale of an item.

The expression for the size of the bubble tells me how many items we sold.

The expression that determines the color of the bubble (the value I can't seem to see) tells me the average discount applied to a sale of this item.

The background color expression is applied to the Average List price formula.

Is there anyway for me to see the value for this fourth expression?

Any help would be much appreciated.

(simplified document is attached)

Re: Displaying a color expression value on scatter chart

rbecher — Mon, 02 Mar 2015 10:32:37 GMT

Hi Nathan,

please find attached. You can just add another expression and check "Text as Popup".

- Ralf

Re: Displaying a color expression value on scatter chart

Roop — Mon, 02 Mar 2015 12:08:57 GMT

I would suggest adding the expression for Discount as:

'Discount = ' & avg([% Discount] * [Avg Achieved])

and then checking the button that says "Text as Pop-up".

This will give the discounted value in a pop-up when you hover over the relevant bubble.

topic Displaying a color expression value on scatter chart in QlikView

Displaying a color expression value on scatter chart

Re: Displaying a color expression value on scatter chart

Re: Displaying a color expression value on scatter chart