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: 
Not applicable

subselect query

Hi,

Can we write subselect query in Qlikview? the example is below.

select name,(select jobName from usersjob where usersjob.userid=users.id) as JobName from users

Thanks,

2 Replies
Gysbert_Wassenaar

If you use an sql select statement then that is send to the database as is. Qlikview doesn't process it, the dbms it is send to does. So you can do whatever you want in sql as long as your dbms supports it.

The load statement can't do 'subselects'. The usual way is to use the exists function in a where clause or use the keep function. Here's a discussion with an example of both.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks for answer but actually we will get those records from qvd file and those tables are not in a same database.  I tried to ask basic question for it.