Direct Discovery: Show top n rows on a table

[matteogm]

Hi,

I would like to show only top 100 rows that come from Direct Discovery on a table box. I defined those field as DETAIL on script.

How can I define top 100 rows limitation in the "DIRECT QUERY" script? Is it possible?

Thanks

[marwen_garwachi]

Hi,

Could you share your query ?

Thx,

Marwen

[matteogm]

Direct query on Qlikview script is:

DIRECT QUERY

DIMENSION

Title

DETAIL

Date,

Access

FROM generated;

Title is also a filter on dashboard.

I would Like to retrieve:

SELECT

Title,

Date,

Access

FROM generated

LIMIT 100;       

(MySQL)

WHERE conditions come from Title selection filter.

Is possible to define LIMIT 100 in Direct Discovery?

[cristian_av]

Hi

As far as I know, you cannot limit in the load script. But you can use Calculation Conditions on each chart that uses the Direct Discovery