Discussion board where members can get started with Qlik Sense.
I create the following table in the script:
Load ID AS APP_ID
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..
IF(UPPER(STATUS)='HIRED' and ID EXISTS IN APP_ID from table Hired_Application ,DAYS)
Could you please advise?
Go to Solution.
try loading the field again by different name in data model
Load ID AS APP_ID,
ID AS APP_ID1
IF(UPPER(STATUS)='HIRED' and ID=APP_ID1 ,DAYS)
It would be great if you provide sample data