Discussion Board for collaboration related to QlikView App Development.
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
Go to Solution.
View solution in original post