Selective filtering of data in table

Question & Answer
, , , , ,
1

I have a quick question wrt filtering using params. The sit is as follows -

  1. Have a horizontal stacked bar chart showcasing data from one dataset
  2. Have a table showcasing data from another dataset

Both the datasets are linked by 1 field
And i have set up a filter action on Bar chart so that contents of table are filtered out.

Now, the query is something like -
When there is no selection made on chart, I want the table to display nothing.
Only if there is a selection made on chart, the table should display filtered contents.

Any ideas on how do I achieve this?

2

Cann you please share sample data in Arena.

3

Hi @vgishere

You can use the IN function to check if there is any value selected or not in your parameter and a set boolean 0 if there is no selection or a 1 if there is a selection. Add a filter on this calculated field where the value = 1.

See the following post for help woth the IN function on a parameter.

1 Like