Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

RutiTRubin
Contributor

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
Valued Contributor

Re: Where exists in expression- Qlik sense

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

1 Reply
passionate
Valued Contributor

Re: Where exists in expression- Qlik sense

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

Community Browser