topic Re: Compare the data and then count in QlikView

Compare the data and then count

varunreddy — Fri, 09 Jun 2017 20:23:18 GMT

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!

antoniotiman — Fri, 09 Jun 2017 21:22:22 GMT

Hi Varun,

See Attachment.

Regards,

Antonio

sunny_talwar — Fri, 09 Jun 2017 21:35:01 GMT

This can also work

=Count({<ID = {"=Only({<['A'] = {'A'}>}ID) = Only({<['B'] = {'B'}>}ID)"}>}ID)

varunreddy — Fri, 09 Jun 2017 21:45:17 GMT

I tried it, before posting. Not sure why it didn't work

varunreddy — Fri, 09 Jun 2017 21:51:25 GMT

Thanks for your response.

Cheers,

varunreddy — Fri, 09 Jun 2017 21:52:23 GMT

Sunny,

Thanks for your response again.

I used the same expression but used two equal to signs

Cheers,