
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where exists in expression- Qlik sense
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!!
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
