Resident Sub query

[SahrierParvez]

hi, I want to do sub Query in resident in Qlikview

[asinha1991]

you cannot do subquery, there are ways to achieve things...tell scenario example...tips for subquery in where clause

try to store subquery result in a table(separate load statement) and use join or exist  to limit the main table with this table.

if your subquery returns 1 value, use peek to store it in a variable and then use that variable in where clause

[Brett_Bleess]

Sahrier, if the other post did not help, I would suggest providing a bit more detail on your use case here such that some of the other members may be able to come up with some other ideas at that point.  It is very important to provide as much info as you can when posting, this will result in more and better responses in most cases.

You can check the Design Blog area, that is about the only place of which I can think you may find something that might help:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Generally best to start with one word search and narrow from there...

Regards,
Brett