0 Replies Latest reply: Feb 2, 2017 7:55 AM by Daniel R P RSS

    Nested Select in Qlik Sense

    Daniel R P



      I'm trying to make this sql query with sense:


      SELECT t1.name,


              nvl(t1.date, (SELECT t3.date from t3 WHERE t3.name=t1.name)) as date,

               //other t1 and t2 fields

              FROM t1 INNER JOIN t2 on t1.id=t2.id


      Inner join is not a problem but I don't know how to get date field. Can anyone help?


      I was thinking about mapping, but I really don't know how to use it with two conditions.