Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Nested Select in Qlik Sense

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.

0 Replies