Show a table based on selection

[Anonymous]

I have 3 tables displayed in a Qlikview app.  TableA, TableB & TableC.  I want to be able to select a table name from a list box and only display that table.  If no table is selected in the List Box then no tables should appear.

Each of my tables has a conditional statement as follows ( for TableA is looks like this):

                               =WildMatch('|'& Concat(Table_list, '|') & '|', '*|TableA|*')

I have built a list of tables in a ListBox.  When I select TableA from the ListBox it appears on the form and the other tables disappear.  When I clear the ListBox selection, ALL the tables reappear.  This is when they should all be hidden.

I have also tried :  =SubStringCount(Concat(Table_list,'|'),'TableA') and get the same results.

Any thoughts as to how to have the tables hidden until a selection is made in the ListBox?

Thanks for your help.

Ed

[sunny_talwar · Accepted solution]

Try this:

WildMatch('|' & GetFieldSelections(Table_list, '|', 100) & '|', '*|TableA|*')

[Anonymous]

That worked perfectly.  Thank you. 

Can you briefly explain why this worked and mine did not?

[sunny_talwar]

Getfieldselections only lists a selected field.... when nothing is selected it is null. Whereas Concat looks at the possible value. If nothing is selected, it will concat all possible values.

[Anonymous]

Makes sense.  Thanks.