Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

New Contributor

Resident Sub query

hi, I want to do sub Query in resident in Qlikview
1 Reply
Contributor III

Re: Resident Sub query

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