Show tables based on user selection

[jjustingkm]

I have a container with 3 tables, for example sales, order ,shipment. I am trying to select the container table based on my selection for example the sales table will be
selected if user selects sales value. I can bring sales, order and shipment as dummy values in a table.

[rubenmarin1 · Accepted solution]

Hi, you can use the "show if" condition of each chart of the container to do that, if you have a Table field with Sales, Order and Shipment values you can use an expresssion like: Index(Concat(Table),'Sales')

So if Sales is between the possible values, it will be selected.

If you only want one table to be shown you can use the variable input object (on custom objects), create a variable, configure the variable to set the 3 different values, you can use the 'show as' section to show as button, so at the end the user has 3 buttons to selct the table, and each one is shown based on a differnt variable value.

You can use the variable in the show if condition of the table as $(buttonPressed)=1, If Sales has the value 1, it will show the Sales table.