Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Ayoub
New Contributor III

Nested query

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Nested query

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

View solution in original post

2 Replies
Partner
Partner

Re: Nested query

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

View solution in original post

Partner
Partner

Re: Nested query

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;
Plees ekskuse my Swenglish and or Norweglish spelling misstakes