topic Re: Show a table based on selection in QlikView

Show a table based on selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Show a table based on selection

sunny_talwar — Tue, 07 Feb 2017 21:59:44 GMT

Try this:

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

Re: Show a table based on selection

Anonymous — Tue, 07 Feb 2017 22:07:45 GMT

That worked perfectly. Thank you.

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

Re: Show a table based on selection

sunny_talwar — Tue, 07 Feb 2017 22:11:26 GMT

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.

Re: Show a table based on selection

Anonymous — Tue, 07 Feb 2017 22:12:14 GMT

Makes sense. Thanks.