Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Could you share your query ?
Thx,
Marwen
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?
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