Expand Table when the visual contains information

Q&A
,
1

Hi,

Can you please help me to find a similar solution at Quick?

In Tableau there is an option to expand table when it shows any data by filtering other visual (see below)

  1. The original bar chart.

  2. when you click on one of the bars it filters out the table and then the table appear

image
image598×251 3.51 KB

  1. when you click on the same bar again, it disappears

How can i achieve something like that at Quick? :slight_smile:

Many thanks,

Kate

2

Hi @kate.peacock and welcome to the Quick Community!
This exact functionality is not native to Quick, but there could potentially be work around options; however one thing the one aspect that will be hard to replicate will be the single click action that shows/hides the table.
In regards to setting up a work around; you’ll first need to make sure your layout is set to ‘free-form’ (Edit → Analysis Settings → Sheet Settings) as this allows you to apply rules (which hide and show visuals).
Build a table visual that holds the desired information you’d like to show (based on the selection/filter of your first visual).

Next we need to build some parameter to handle the action/filtering. Set up a parameter for the field you’d like to filter by. You can just set the default value as ‘ALL_VALUES’.
And then you’ll also want to setup a static parameter that can be used to hide and show the table. In my example I just named it ‘HideShow’. Since I won’t be adding a control for it, the naming does not matter. You don’t need to set a default value as it’s not needed for this scenario.

Now we can start building the action and rules for the visuals. Setup a navigation action on your bar chart, it’ll look similar to below:

image
image342×956 27.9 KB

So you’ll want to add the parameter for the field that’s filtering down and for ‘set parameter value’, add in the ‘Field’:…’ option. Then add in the HideShow parameter and for ‘set parameter value’, you’ll set it as custom and then ‘Show’.
On you table visual, first setup a rule..switch on the ‘hide this visual by default’ option and then set the rule so that when parameter ‘HideShow’ equals ‘Show’, show the visual:

image
image374×514 13.3 KB

Then setup an action on the table as well (which will be to re-hide the table). Setup a navigation action that sets the parameter ‘HideShow’ to custom value, and add in ‘Hide’.

I put together a very simple example in Arena view for you to review and see the logic that was used to build. If you select a bar, it will pop open the table, then if you select a row in the table it will hide it again.
Once opened, you can hit the ‘Copy Analysis’ button on the left hand side to see the analysis view/what it looks like behind the scenes.
Expand Table when the visual contains information

1 Like
3

Thank you very much @Brett.

That’s a very good work around. I just didn’t think to use a Navigation action on top of it. It makes sense :slight_smile:

1 Like