Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Formula to retrieve differences between 2 tables

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

1 Solution

Accepted Solutions
Not applicable

Re: Formula to retrieve differences between 2 tables

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)

3 Replies
Not applicable

Re: Formula to retrieve differences between 2 tables

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

sureshqv
Esteemed Contributor III

Re: Formula to retrieve differences between 2 tables

how the result table is  taking?

means u want which is not there in table1 values?

Not applicable

Re: Formula to retrieve differences between 2 tables

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)

Community Browser