topic Nested query in QlikView

Nested query

Ayoub — Wed, 03 Apr 2019 16:27:35 GMT

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

Re: Nested query

dplr-rn — Wed, 03 Apr 2019 16:38:49 GMT

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/InterRecordFunctions/Exists.htm

- 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

Re: Nested query

Vegar — Wed, 03 Apr 2019 17:52:29 GMT

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;