topic Re: Display different value on hover in QlikView

Display different value on hover

Fri, 09 Jan 2015 14:20:33 GMT

Hello,

I have a scatter chart where I have plotted Product IDs. However, when you hover over the points, I would like to have the Product Description display, rather than the Product IDs. I have to plot IDs over Descriptions because the relationship is not 1-1.

Any ideas on how to do this?

Thank you,

Mel

Re: Display different value on hover

jpenuliar — Fri, 09 Jan 2015 15:02:15 GMT

You can try adding another expression " ='Product Description : ' & [Product Description] " and tick Text as Pop-up

Re: Display different value on hover

jpenuliar — Fri, 09 Jan 2015 15:03:48 GMT

Keep in mind, the third expression dictates the bubble size, so you would want to add it after that

Re: Display different value on hover

jpenuliar — Fri, 09 Jan 2015 15:05:37 GMT

You can also add Product Description as first Dimension

Re: Display different value on hover

MarcoWedel — Fri, 09 Jan 2015 16:48:35 GMT

Hi,

another solution could be a calculated dimension that generates dual values (Product ID (if numerical) formated as Product description):

=Dual([Product Description],[Product ID])

Using the Product description directly as the first dimension would require it to e unique like the Procuct ID.

Otherwise the bubble count and positions could change.

hope this helps

regards

Marco