topic Re: Ignore all fields from one table without Set Analysis in App Development

Ignore all fields from one table without Set Analysis

t_donnet — Sat, 16 Nov 2024 19:57:09 GMT

hi,

I've a condition to establish.

If one or more fields from a specific table is selected -> value A else value B.

I try to avoid all fields from a calendar table. Any way to ignore those fields without set analysis ?

Re: Ignore all fields from one table without Set Analysis

Vegar — Mon, 07 Oct 2019 10:43:16 GMT

You can't really check if any field in a table is selected, but you can check for each field in the table using getSelectedCount() .

Re: Ignore all fields from one table without Set Analysis

Vegar — Mon, 07 Oct 2019 10:44:05 GMT

You can't really check if any field in a table is selected, but you can check for each field in the table using getSelectedCount().

Re: Ignore all fields from one table without Set Analysis

t_donnet — Mon, 07 Oct 2019 11:32:28 GMT

I was going to use getSelectedCount() and yes that's a good way for a few fields.

But how about more than 20 fields?

Re: Ignore all fields from one table without Set Analysis

jfkinspari — Mon, 07 Oct 2019 11:43:26 GMT

You could create a variable, that loops over all fields in the calendar table and create the corresponding set analysis syntax, that you then can use in your measure

Re: Ignore all fields from one table without Set Analysis

sunny_talwar — Mon, 07 Oct 2019 11:56:13 GMT

May be this is one of the options you can try

Ignore all selections except some specific fields using Set Analysis

Re: Ignore all fields from one table without Set Analysis

Vegar — Mon, 07 Oct 2019 12:59:16 GMT

You could do something like this to avoid listing the field values manually:

=if( $(=concat({<[$Table] = {'MasterCalendar'}>}'getSelectedCount(['& $Field &'])', '+')) > 0, 'Value A (One or more calendar field is selected)', 'Value B (No Calendar field values are selected)' )

Re: Ignore all fields from one table without Set Analysis

t_donnet — Mon, 07 Oct 2019 13:32:52 GMT

That's what I'm looking for.

Thanks a lot @Vegar