Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Yojas Samarth
Please check tresesco attached qlikview and script, it worked.
Thank you.
best regards,
jason