Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
twanqlik
Creator
Creator

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
sunny_talwar

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

View solution in original post

7 Replies
sunny_talwar

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

twanqlik
Creator
Creator
Author

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

sunny_talwar

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
Champion III
Champion III

May be this?

Use an expression like

= GetSelectedCount(Firstname) > 0

Capture.PNG

vishsaggi
Champion III
Champion III

hahah. I am late. 😉

twanqlik
Creator
Creator
Author

Thank you!

Ame
Contributor III
Contributor III

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

Regards,