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?

[MK_QSL]

Can you provide sample file for this?

[senpradip007]

Use a trigger on "Leave Sheet", clear the field of Region and %spendFlag.

[sasikanth]

HI,

Try this expression

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

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

Also use the trigger Clear All on leave sheet and reset the clear state (Selection-->Reset Clear state ) if enabled

[senpradip007]

Sunny,

Expression may be like, Aggr(Only({<%spendFlag={1}>}Region)Region)

[tresesco]

One more correction (comma) - Aggr(Only({<%spendFlag={1}>}Region) , Region)

Though I am not sure, if this helps the original case of query. May be a sample qvw could help us help better.

[#7]

Here is an example file. In the second sheet for example, I cannot select stockholm.

Regards

[sasikanth]

HI,

PFA  Added trigger

[#9]

Thanks for the solution. I cannot use the clear all trigger. I only want to clear the flag. If you use the clear field trigger, you can notice that it does not work

Regards

[sasikanth]

You are making selections on City field so you should clear the city field in order to see no selections in next sheet

i dont think there is a meaning if you clear %Flag.

if i missed please explain what you are trying to achieve