topic Copy selected value from one field to another set analysis in App Development

Copy selected value from one field to another set analysis

Micki — Thu, 25 Mar 2021 08:28:43 GMT

Hi folks,

Have 2 tables that are not linked.

My case:

- user select value from T1 field1 - 22-12-20

- user select value from T2 field2 - 23-12-20

And now I need to copy value from T2 field2 - 23-12-20 to T1 field1 - 22-12-20 in set analysis

So like SUM( {< field1= {'22-12-20, 23-12-20'} >}items)

Does it possible?

Thank you in advance

PrashantSangle — Thu, 25 Mar 2021 08:35:58 GMT

yes it is possible. use getfieldSelection()

Regards,

Prashant Sangle

Micki — Thu, 25 Mar 2021 10:11:21 GMT

@PrashantSangle , good to know that is possible:), could you please provide an example or fix my example

What i Did:

Sum({<[Field1]={"$(var), $(var1)"}>} items)

Var =Replace(GetFieldSelections([Field1]),', ','","')

Var1 =Replace(GetFieldSelections([Field2]),', ','","')

So when i select one date from Field 1 and another from Field 2 it's not showing the anything

rwunderlich — Sun, 28 Mar 2021 15:31:00 GMT

The Set Analysis function used to filter from a not-linked field is P().

SUM( {< field1 = P(field2)>}items)

In your case it looks like you want to match selections from both field1 and field2. So:

SUM( {< field1 = P(field1)> + < field1 = P(field2)>}items)

SUM( {$ + < field1 = P(field2)>}items)