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

    Nested Select in Qlik Sense

    Daniel R P

      Hello,

       

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

       

      SELECT t1.name,

              t2.description,

              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.