Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can Aggr function/Subquery used in Direct query

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

1 Reply
marcus_sommer

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

- Marcus