topic Formula to retrieve differences between 2 tables in App Development

Formula to retrieve differences between 2 tables

Wed, 05 Jul 2017 07:36:16 GMT

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:

Table Skills requested:

Skills requested

Java

Python

Spark

The aim is to get the differences:

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

Many thanks in advance,

Nicolas

Wed, 05 Jul 2017 07:49:55 GMT

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

Chanty4u — Wed, 05 Jul 2017 11:42:45 GMT

how the result table is taking?

means u want which is not there in table1 values?

Wed, 05 Jul 2017 12:07:05 GMT

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)