Skip to main content

Query

ON THIS PAGE

Query

Query enables direct custom selection and retrieval of Qlik Catalog tables through query language. The results display in standard grid format.

Query results are limited to 1000 rows. These results can be exported as comma separated values (CSV) or Excel spreadsheet (XLS) formats, the query re-executes upon export.

Select Query from top right corner of any discover screen.

Select Query

Below illustrates a Select statement to retrieve two fields (value, year) from entity (CPIUSHousing) in source (INDEXSN).

Create a query

Write a custom query and select Run Query, Data Output displays in lower half of screen

Query profile values

A distribution table with detailed field profiling metrics is created for each entity (regardless of profile data method setting in core_env).

Run a simple query with the following syntax to display profile metrics:

select * from <sourcename>.<tablename>_profile;
Select query for field profile metrics

Select query for field profile metrics

Export the results as comma separated values (CSV) or Excel spreadsheet (XLS) formats by selecting the option and downloading the file.

Export query results

Export query results and the XLS or CSV is downloaded to local machine