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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
matteogm
Partner - Contributor III
Partner - Contributor III

Direct Discovery: Show top n rows on a table

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

3 Replies
marwen_garwachi
Creator II
Creator II

Hi,

Could you share your query ?

Thx,

Marwen

matteogm
Partner - Contributor III
Partner - Contributor III
Author

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
Creator III
Creator III

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