Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
What output are you looking to get in the sample attached?
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
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
May be this?
Use an expression like
= GetSelectedCount(Firstname) > 0
hahah. I am late. 😉
Thank you!
Hi, Is there a way to do this on Qlik sense?
Regards,