Flag cannot be cleared from selection

[#1]

Hi,

I have a listbox that has an expression like below

if(%spendFlag = 1, Region)

The listbox is only showing regions that has a %spendFlag = 1. The problem is that if I select any region from the listbox, I cannot select any other regions in other sheets. one reason is that If don't use the hide prefix, I can see in the selection box that along with regions, I also see the %spendFlag=1 in the selection box. If I use a trigger to clear the field %spendFlag upon leaving the sheet, it cannot clear %spendFlag and without clearing this field, I cannot select other regions on other sheets. I can only select the regions where %spendFlag = 1

Any solution for this?

[marcus_sommer]

Instead of a clear-action you could use a select action in this field with a reversed logic:

= null()

which will clear any selection in this field.

- Marcus

[#3]

OK so the purpose is that I do not want the City field to be cleared. I am clearing the flag because on the next page, I want to see the current cities selected but I also want the other cities to be selectible. If the %flag =1, then we cannot select the cities where %flag=0.

Simply, on the main page, I only want the listbox to select the cities where %flag=1. On sheet 1, I also want to be able to select other cities. While doing this, I do not want to lose the cities selections while moving between sheets

Regards

[rubenmarin]

One improvement (I think), to keep seeing non-selected values:

=Aggr(Only({1<%spendFlag={1}>}Region), Region)

Selections are made in the Region field, not in the spendFlag field, wich seems was the problem in the original post.

[sasikanth]

HI,

i added  clear %flag trigger

See attachment

[MK_QSL]

Like this?