similar field name but different line item query

[sudeep_d]

I have 2 different tables ,one having region name1 and another as regionname2 as field name which has similar states name.When i select state name from regionname1 then the expression from table 2 reflects wrong output since it takes line item from 1st table and vice versa. So is there any method so that if we select state name from regionname1 then the expression calculated for table 2 takes statename from regionname2 so that the expression gives correct output.

eg:   regionname1   regionname2

        Ohio               Ohio

        illinois              illinois

but here if we select illinois from regionname1 then expression from table 2 gives output as '48' which is false but if we select illinois from regionname2 then it gives output as '63' which is true.

what i want is if we select illinois from regionname1 it should give me output as '63'

Thanks

[Jason_Michaelides]

I'm not sure I understand.  Can you post an example of your application?

[#3 · Accepted solution]

Hi,

You can use set analysis here to get the required results but I don't think it is a good practice to have two region fields, better is to have a common link.

Anyways to use set analysis

supoose you want sum of sales then for table 2 data

sum({< region1 =, region2 = p(region1) >}sales)

make sure to keep only 1 field as a selection field, which I assume is region1.

...

Ashutosh

[sudeep_d]

Thanks Ashutosh,

The mentioned set analysis solved my issue

@ jason Thanks for ur concern

regards

Sudeep