Announcements
cancel
Showing results for
Did you mean:
Creator

## Intersection in two alternate states

Hello all,

I have a simple inline data:

```test:
PLACE, VALUE
A, 4
A, 5
A, 6
A, 7
A, 8
B, 1
B, 2
B, 3
B, 4
B, 5
B, 9
];
```

then I created two alternate states ([Group 1] and [Group 2].  I want to count the number of "intersection(s)' in dimension PLACE between the two alternate states. In the data (A and B), they have two the same values (4 and 5).  I tried some script (below) from a comment from another thread

```=Count({[Group 1]<PLACE*=p({\$}PLACE::PLACE)> * [Group 2]<PLACE*=p({\$}PLACE::PLACE)>} VALUE)
```

but it only displayed 0, not 2.  I have attached the image below:

Please check if I missed something or the code is wrong.

Thanks in advance and best regards,

Jason

1 Solution

Accepted Solutions
MVP

Hello Jason,

PFA.

Use expression: =Count({[Group 1]<VALUE=P({<PLACE=[Group 2]::PLACE>})>}VALUE)

10 Replies
Not applicable

Hi Jason,

Can you attach your testing appication? That will be more understandable.

Thanks!!

Regards,

Yojas

Creator
Author

Hello Yojas,

best,

Jason

Not applicable

Hi

Creator
Author

Hello Nirmal,

Thanks for the qvw file.

However, there are only two data from A and B that are the same (4 & 5), how come your script yielded 11?

best,

Not applicable

Sorry Jason after that i saw the exact requirement

Not applicable

Hi Jason,

I hope it hte same which you were expecting!!!

Regards,

Yojas

MVP

Hello Jason,

PFA.

Use expression: =Count({[Group 1]<VALUE=P({<PLACE=[Group 2]::PLACE>})>}VALUE)

Not applicable

Hi Jason,

Please update us if you got your solution by marking it correct !!!

Thanks!!

Regards,

Yojas

Creator
Author

Hi tresesco,

it's correct, thank you very much.

best regards,

jason

Community Browser