Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

twanqlik
New Contributor III

Only show selected values in a Tablebox

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.

1 Solution

Accepted Solutions

Re: Only show selected values in a Tablebox

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


Capture.PNG

6 Replies

Re: Only show selected values in a Tablebox

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

twanqlik
New Contributor III

Re: Only show selected values in a Tablebox

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

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


Capture.PNG

vishsaggi
Esteemed Contributor III

Re: Only show selected values in a Tablebox

May be this?

Use an expression like

= GetSelectedCount(Firstname) > 0

Capture.PNG

vishsaggi
Esteemed Contributor III

Re: Only show selected values in a Tablebox

hahah. I am late. ;-)

twanqlik
New Contributor III

Re: Only show selected values in a Tablebox

Thank you!

Community Browser