topic Re: Direct Discovery: Show top n rows on a table in QlikView

Direct Discovery: Show top n rows on a table

matteogm — Thu, 30 Oct 2014 10:21:18 GMT

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 — Thu, 30 Oct 2014 10:24:41 GMT

Hi,

Could you share your query ?

Thx,

Marwen

matteogm — Fri, 31 Oct 2014 09:30:41 GMT

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 — Mon, 01 Oct 2018 14:26:17 GMT

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