4 Replies Latest reply on Feb 5, 2019 11:39 AM by maneesh.gaddam

Combine Hover and Select Actions

maneesh.gaddam Feb 5, 2019 10:49 AM

Hello all,

I'm wondering if there is any way to have Hover and Select actions to coexist. In my workbook, I have Category and Sub-Category sheets. Two actions (Hover and Select) source from Category to filter respective sub-categories. When I click and go sub-category visualization to view the tool-tip, the action gets cleared (because I'm not hovering anymore) and it shows all values.

I cannot use 'leave the filter' for Hover action as I have to click and unclick any category to show all values. I have browsed through community and there is workaround by creating multiple sheets and use 'exclude all values' but I'm not looking to do that. Please let me know if you have any solution.

Book1.twbx 1.2 MB

1. Re: Combine Hover and Select Actions

Joe Oppelt Feb 5, 2019 11:12 AM (in response to maneesh.gaddam)

If both actions are filtering the same field and going to the same sheet, they're going to conflict.

Make two sheets. Just do Copy Sheet and make a new copy. Have one action control one sheet, and the other action control the other. And then you can use "leave the filter" on each one so that they clear away under the appropriate conditions.
Like Show 0 Likes(0)

Actions
2. Re: Combine Hover and Select Actions

maneesh.gaddam Feb 5, 2019 11:28 AM (in response to Joe Oppelt)

Appreciate the response, Joe.

Creating two sheets is the workaround what I was thinking as well but want to avoid that. I don't know if there is any other workaround without duplicating the sheet but I'll try creating a second sheet.
Like Show 0 Likes(0)

Actions
3. Re: Combine Hover and Select Actions

Naveen B Feb 5, 2019 11:28 AM (in response to maneesh.gaddam)

Hi Maneesh Are you looking like below

this is hover

after selecting

What you need to do is duplicate the category field pass the hover action on original field and select action on duplicated Category Field

like below

Hope this helps
Plz mark this answer as correct or helpful to close the thread

BR,
NB
Like Show 1 Likes(1)

Actions
4. Re: Combine Hover and Select Actions

maneesh.gaddam Feb 5, 2019 11:39 AM (in response to Naveen B)

Thanks a lot, Naveen. This worked

EDIT: This works partially. When I want to make a different Category selection and before clicking on the second category, hovering on it makes the Target sheet go blank because we are inputting different selections through different actions
Like Show 0 Likes(0)

Actions