topic Re: Force selection even without data in QlikView

Force selection even without data

Wed, 23 Mar 2016 15:02:16 GMT

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?

Re: Force selection even without data

Gysbert_Wassenaar — Wed, 23 Mar 2016 16:13:20 GMT

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

Re: Force selection even without data

swuehl — Wed, 23 Mar 2016 17:23:49 GMT

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)