Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Start with a blank table

Usually a table shows 'it all' before any selections has been made - is there a way to have the opposite? Starting with a blank table, I make a selection somewhere else, the table gives me exclusive entries related to the selection. And so on - for each new selection.

2 Replies
spsrk_84
Creator III
Creator III

Hi,

I hope that is not possible since unless and untill if there is no dimension in the table it will not display values .but there i sanother way like

u Can add the dimensiona in the table and mean while Create the Listboxes for those Dimension addded in the table ,Now on the selection of the values in the Listbox the chart can be visible else it will be invisible. i.e if u select any value in the listboc then only the Table BOx appears.

Here u need to put a condition in the Sheet Properties Conditional Show in Layout Tab

In this way we can achieve a part of Your Requirement but not complete one.

Regards

Ajay

vupen
Partner - Creator
Partner - Creator

There could be 2 ways to solve your problem:

1. Show/Hide the table chart based on the current selection count (you can use GetFieldSelections to find that)

2. Have a calculated dimension based on GetFieldSelections, which would return a NULL when no selections are made, and 'Suppress when Value is Null' option selected for the dimension