topic Re: Resident Sub query in QlikView

Resident Sub query

SahrierParvez — Wed, 11 Sep 2019 04:07:49 GMT

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

Re: Resident Sub query

asinha1991 — Wed, 11 Sep 2019 21:18:39 GMT

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

Re: Resident Sub query

Brett_Bleess — Mon, 23 Sep 2019 21:35:16 GMT

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