Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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)

View solution in original post

3 Replies
Not applicable
Author

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

Chanty4u
MVP
MVP

how the result table is  taking?

means u want which is not there in table1 values?

Not applicable
Author

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)