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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Force selection even without data

Hello I´m making a toggle button which turns on and off selection on one column form table box where its value = 0. But the problem is that there is not yet any row which has the 0 value (but in future data there might be this situation). Now when i toggle the button nothing happens at all. It can´t do the selection cause there is no 0 value in this column in any existing row, so the data stay unfiltered. But i want it to select the 0 value anyway and show no data in the table box. Is this possible?

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You cannot select non-existing data. If you want to select 0 then add a dummy record with 0 to your data.


talk is cheap, supply exceeds demand
swuehl
MVP
MVP

Maybe just use a calculation condition or show condition for your table box that checks if the toggle variable (I assume you also toggle a variable) is toggled but no selection made, maybe using something like

=If(vToggle and GetSelectedCount(FIELD)=0, 0, 1)