Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnagutha1294
Partner - Contributor II
Partner - Contributor II

Comparing columns in 2 different tables

Hi All

Having 2 different tables

1st table having fields  A,B,C

2nd table having fields D,E,F,G

Need to write set analysis Expression for comparing (a=d or a=e or a=f)after satisfying the above condition then get  count (A).

Please any one solve the above expression.

Thanks in Advance.

 

Labels (1)
  • SaaS

4 Replies
Taoufiq_Zarra

can you share a sample data and the expected output ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
krishnagutha1294
Partner - Contributor II
Partner - Contributor II
Author

The result need as per attached table.

Vegar
MVP
MVP

You might solve this by using multiple implicit set analysis modifiers like this. 

Count ({<A=p(D)+p(E)+p(F) >} A)

or

Count ({<A=p(D)>} +{<A=p(E)>} +{<A=p(F) >} A)

or similar.

I hope this helps you or at least points you to in a good direction.

- Vegar

Kushal_Chawda

You can add A,D,E & F fields in dimensions and put below expression

=if(A=D or A=E or A=F,1,0)

You can go to Add-on and uncheck  " Include zero values"