select a specific field value with action only if no value is selected

[surajap123]

Hi Experts,

I want to select value2 in a field using Action(in a button) only if the user has not selected any value(before coming to see this report). The report is in a separate sheet, so the user will be coming to this sheet by clicking a button. 

Load * INLINE [
Field
value1
value2
value3
];

Below expression not working

if(GetSelectedCount(Field) = 0, 'value2',Field)

Thanks!

[martinpohl]

use this:

=if(GetSelectedCount(Field)=0,value2,'('&concat(distinct Field,'|')&')')

Regards

[MayilVahanan]

Hi @surajap123 

IF 2 values are selected, then ur expression won't work. Try like below

=if(GetSelectedCount(Field) = 0, 'value2', '('&concat(Field,'|')&')')