Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
taz803
Contributor III
Contributor III

counting commun and different values

I have two columns (RE and RE_D) I want to compare the values ​​and after do a count on the common values ​​and count on the differenetes values ​​and display in a table.

My table should contain:

RE | RE_D | count(commun values) |  count(different values)

how can i hundle it ? , Thanks a lot 

 

Labels (5)
1 Reply
BrunPierre
Partner - Master
Partner - Master

Common values: Sum(If(RE = RE_D, 1, 0))

Different values:  Sum(If(RE <> RE_D, 1, 0))