Skip to main content

Query

ON THIS PAGE

Query

Query enables direct custom selection and retrieval of Qlik Data Catalyst 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 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

Create a Query

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