Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Display different value on hover

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

Tags (1)
1 Solution

Accepted Solutions

Re: Display different value on hover

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])

QlikCommunity_Thread_147918_Pic1.JPG

QlikCommunity_Thread_147918_Pic2.JPG

QlikCommunity_Thread_147918_Pic3.JPG

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

4 Replies
jpenuliar
Valued Contributor III

Re: Display different value on hover

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

jpenuliar
Valued Contributor III

Re: Display different value on hover

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

jpenuliar
Valued Contributor III

Re: Display different value on hover

You can also add Product Description as first Dimension

Re: Display different value on hover

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])

QlikCommunity_Thread_147918_Pic1.JPG

QlikCommunity_Thread_147918_Pic2.JPG

QlikCommunity_Thread_147918_Pic3.JPG

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

Community Browser