1 Reply Latest reply: Apr 15, 2018 3:21 AM by Pankaj Thakur RSS

    Where exists in expression- Qlik sense

    ruti t

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