Nested Select in Qlik Sense

Anonymous — Thu, 02 Feb 2017 12:55:52 GMT

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.

topic Nested Select in Qlik Sense in App Development