Can Aggr function/Subquery used in Direct query

[Anonymous]

Hi All,

   My direct discovery works like below

DB_CONNECTION

Direct Query

Dimension

F1,

F2

,F3

Measure

M1

M2,

M3

From Table_Name;

However I need to use the sub query which is the requirement in the Data pull

SELECT * FROM F_INST WHERE (DATE_SK, D_AG_SK)

                                                                                         IN   (SELECT MAX(DATE_SK),D_AG_SK

                                                                                                 FROM F_INST

                                                                                                 group by D_AG_SK);

I am using QV 11.20 SR6. All I want is can we use Aggr and Subquery in the Direct Discovery query?

-Jay

[marcus_sommer]

Have you looked into the various resources here: https://community.qlik.com/search.jspa?q=direct+discovery&type=document‌?

- Marcus