Nested query

[Ayoub]

Hello,

I'm a new to Qlikview and i need your Help. 

i have two table: 

 1) Reference (ID,Date, Statut)

2) Client (ID, FName,LName) 

and i wan't to do a nested query like this : 

Select ID,FName,Lname, Date,Statut 

from Reference ,Client 

Where Reference.ID =  Client.ID

and Client.ID in ( Select ID from Reference where Date=date('02/04/2019','DD/MM/YYYY');

Is that Possible ? 

thanks in advance

[dplr-rn · Accepted solution]

Yes but couple of things
- Is your nested query a sql ? if so yes no issues you can do it
- or if its completely within qlik script. - it is possible but not exactly like a sql query. you will have to create a temporary table with just IDs with the condition and use exists to do the filter
https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...

- another option (if the requirement is for a specific chart and not the whole app) is to do this through set analysis in the front end

[Vegar]

I think this is what you are looking for.

Table:
Load ID,Date, Statut from Reference
Where Date=date('02/04/2019','DD/MM/YYYY');

Left Join (Table)
Load
ID, FName,LName
from Client;