topic Re: Only show selected values in a Tablebox in QlikView

Only show selected values in a Tablebox

twanqlik — Thu, 10 Aug 2017 16:18:08 GMT

I have a big table on my presentation layer with a few million records. The table has only a few standard fields like:

- Name

- Country

- Product registration

- Email address

- Etc.

Based on those fields i've created a few list boxes that enables to search in the table, however, i only want to show the selected values in the table, hence, when there is no selection the table should be empty.

Can someone give me some advice on how to do this?

I've added an example, maybe that helps.

Re: Only show selected values in a Tablebox

sunny_talwar — Thu, 10 Aug 2017 16:20:44 GMT

What output are you looking to get in the sample attached?

Re: Only show selected values in a Tablebox

twanqlik — Thu, 10 Aug 2017 16:29:23 GMT

What a fast response, as always!

When the .qvw is launched there is data in the table, i would like to see an empty table.

1. Open dashboard --> Empty table

2. Make a selection --> Data will be shown in the table

3. Remove all the selections from the list boxes --> Empty table

Re: Only show selected values in a Tablebox

sunny_talwar — Thu, 10 Aug 2017 16:31:17 GMT

Use a calculation condition to make sure that the table displays a result only when a selection is made.... I used this statement

=GetSelectedCount(Firstname) > 0

Re: Only show selected values in a Tablebox

vishsaggi — Thu, 10 Aug 2017 16:34:41 GMT

May be this?

Use an expression like

= GetSelectedCount(Firstname) > 0

Re: Only show selected values in a Tablebox

vishsaggi — Thu, 10 Aug 2017 16:35:14 GMT

hahah. I am late. 😉

Re: Only show selected values in a Tablebox

twanqlik — Fri, 11 Aug 2017 13:24:57 GMT

Thank you!

Re: Only show selected values in a Tablebox

Ame — Fri, 13 Mar 2020 12:48:59 GMT

Hi, Is there a way to do this on Qlik sense?

Regards,