Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

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!!

1 Solution

Accepted Solutions
passionate
Specialist
Specialist

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

View solution in original post

1 Reply
passionate
Specialist
Specialist

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