Discussion board where members can learn more about Qlik Sense App Development and Usage.
The following issue is quite simple to explain, but no solution found yet in the forums..
There are 2 tables:
Table Skills available:
Table Skills requested:
The aim is to get the differences:
Could we do that in the formula expression field in Qlik Sense?
Many thanks in advance,
Go to 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)
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?