Intersection in two alternate states

[jasonseril]

Hello all,

I have a simple inline data:

test:
LOAD * INLINE [
  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

[jasonseril]

Hello Yojas Samarth

Please check tresesco attached qlikview and script, it worked.

Thank you.

best regards,

jason