Formula to retrieve differences between 2 tables

[#1]

Hello all,

The following issue is quite simple to explain, but no solution found yet in the forums..

There are 2 tables:

Table Skills available:

Skills available
Java
Python
VBA

Table Skills requested:

Skills requested
Java
Python
C#
Spark

The aim is to get the differences:

Skills missing
Spark
C#

Could we do that in the formula expression field in Qlik Sense?

Many thanks in advance,

Nicolas

[#2]

Note: actually, we search the differences that are in Table "skills requested" and not in "skills available", but not the contrary.

[Chanty4u]

how the result table is  taking?

means u want which is not there in table1 values?

[#4 · Accepted solution]

Actually, they are separated columns in different tables.

I've found the solution

if(aggr(count(distinct RequestedSkill)-count(distinct if(RequestedSkill=AvailableSkill,RequestedSkill )),RequestedSkill)=1,RequestedSkill)