I have 1 drop down having 5 values(value 1 ,value 2,value 3,value 4,value 5) in it.
i have assigned a token to this drop down
For (value 1 ,value 2,value 3,value 4)
i have a table(table 1) below drop down where the results change as per values of the drop down selected.
It uses 1 query underneath to get details
what i want is to have another another table(table 2) which should display in place of table 1 [hide table 1 and display 2 instead ] when value 5 is selected from drop down. This needs to use different query
How to achieve this ?
Hi @Pranita_P
For each table click on the Visualisation dropdown on the right and select the "When data is unavailable, hide element" checkbox. This means that the table will not show when there are no results.
Now you need to make it return no results when value5 is/isnt selected depending on your dropdown. You can do this with a where statement on each table (it might not be the most efficient to use a where statement here but not sure how else you could achieve it).
You would add something like:
| where "$yourDropdownToken$"="value 5"
Obviously you can change = to != as required.
🌟 Did this answer help you? If so, please consider:
Your feedback encourages the volunteers in this community to continue contributing