Qlikview does not know sub-queries. If you create a select statement in the Qlikview script (or any sql statement preceded by the SQL keyword) then that statement is not processed by Qlikview, but send to the database server for execution. That means you can (in fact must) use the SQL dialect your database server understands. If your database server can handle sub-queries then you can use them in the sql statement.
You can not use Sub Queries into qlikview like which is SQL, but you can use resident table or any other table load and then use Joins ( inner, left , right ) and make single table out of that tables bu conditions.
Use QlikView functions in order to achieve it. For instance, having the following SQL Statement in a traditional applcation
SELECT department_name, employee_name, count(*) as numberOfEmployees FROM EMPLOYEE where EMPLOYEE.ID_DEPARTMENT = DEPARTMENT.ID_DEPARTMENT AND DEPARTMENT.ID_DEPARTMENT IN (SELECT ID_DEPARTMENT FROM REGION WHERE ID_REGION="NORTH") group by department_name;
In QlikView , forget abut the latter statetement 🙂 , it is very easy, since QView in the majority of its objects aggregates automatically. For instance, the result in a straight chart table would be:
1) Add the following as Dimensions
department_name, employee_name
and then
2) Add the following Expression and label it as numberOfEmployees
IF (ID_REGION = 'NORTH',COUNT(employee_name),0)
or
IF (MATCH(ID_REGION , 'NORTH'),COUNT(employee_name),0)
