Clear button not working with select in field triggers

[#1]

Hello,

I have a field called %HistoricalMarket and one called %Market.

I have not made these two fields into the same field as it would create a loop in my data model.

To simulate that the two fields are the same, I have applied the following triggers:

%HistoricalMarket

On Select - Select in Field %Market

Search String - if(count(distinct %Market) =1,%Market

%Market

On Select - Select in Field %HistoricalMarket

Search String - if(count(distinct %HistoricalMarket) =1,%HistoricalMarket

This seems to work well, though when I select Clear Selections, these two fields will not clear. I can clear them manually within my Current Selections box by selecting the eraser icon.

Is there a way to add another trigger or modify the existing to ensure my Clear Selections button (using 'Clear All') will work on these fields?

Many thanks

Mel

[agomes1971]

Hi,

please see

Clear Selection button

HTH

André Gomes

[PrashantSangle]

Hi,

May i know on which trigger you are calling above two trigger?

I mean it is on ActivateSheet or something else.

Regards,

[rubenmarin]

Hi Mel, if you want to transfer selections from one field to another it shouldn't be..?:

%HistoricalMarket

On Select - Select in Field %Market

Search String - if(count(distinct %HistoricalMarket) =1,%HistoricalMarket