Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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)