Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to lookup if the same data from one table A is available in table B and trying to count it.
For example
Table A has 10 values and Table B has 5 values and 3 values are in common. I want those three values. I have tried few things, but it is not working.
The expression I am trying.
=Count({<[ID] = {"=only({<['A'] = 'A'>}[ID]) = =only({<['B'] = 'B'>}[ID])"}>}[ID])
Attached source file and QVW for reference.
Thanks in advance!
Hi Varun,
See Attachment.
Regards,
Antonio
This can also work
=Count({<ID = {"=Only({<['A'] = {'A'}>}ID) = Only({<['B'] = {'B'}>}ID)"}>}ID)
I tried it, before posting. Not sure why it didn't work
Thanks for your response.
Cheers,
VK
Sunny,
Thanks for your response again.
I used the same expression but used two equal to signs
Cheers,
VK