Where exists in expression- Qlik sense

[RutiTaumanRubin]

Hi everyone,

I create the following table in the script:

Hired_Application:

Load ID AS APP_ID

WHERE PRE_STATUS='HIRED'.

In the expression I want to add a condition (in red below) that the expression will calculated only the id's that exists

in table Hired_Application..

Avg(aggr(

IF(UPPER(STATUS)='HIRED' and ID EXISTS IN APP_ID from table Hired_Application ,DAYS)

,JOB_REQ_ID,FROM_STATUS,TO_STATUS))

Could you please advise?

Thank's!!

[passionate · Accepted solution]

try loading the field again by different name in data model

Load ID AS APP_ID,

ID AS APP_ID1

WHERE PRE_STATUS='HIRED'.

and use

Avg(aggr(

IF(UPPER(STATUS)='HIRED' and ID=APP_ID1 ,DAYS)

,JOB_REQ_ID,FROM_STATUS,TO_STATUS))

It would be great if you provide sample data