Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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# | |
|
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
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)
Note: actually, we search the differences that are in Table "skills requested" and not in "skills available", but not the contrary.
how the result table is taking?
means u want which is not there in table1 values?
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)