topic Re: Using GetFieldSelections() to return available values from a field after selections are made in another field in App Development

Using GetFieldSelections() to return available values from a field after selections are made in another field

mikegrattan — Fri, 30 Aug 2024 17:02:04 GMT

I'm wondering if it's possible to use GetFieldSelections() in the following way:

I have a 'flag' dimension that is set up in the data load script as: if(date(date#("CLDATE",'MMDDYY')) >= Today()-28,1,0) as Flag_PastMonth
When I select Flag_PastMonth = 1 in a sheet, there may be more than one YearPeriod represented, such as 2024-8 and 2024-9.
I would like the function GetFieldSelections("YearPeriod") to return 2024-8 and 2024-9, but since these values are not actually selected, it returns nothing.

Thank you for any advice.

marksouzacosta — Fri, 30 Aug 2024 18:17:11 GMT

What about using something like:

=Concat([YearPeriod],',')

Regards,

Mark Costa

mikegrattan — Fri, 30 Aug 2024 19:55:59 GMT

I tried Concat but got repeating values. However, Concat(distinct YearPeriod,',') works fine. Thanks.