Skip to main content Skip to complementary content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Creating a nominal correlation analysis

Last updated: 2026-09-17

Before you begin

A database connection is created in the Profiling perspective.

About this task

In the example below, you want to create nominal correlation analysis to compute the minimal and maximal birth dates for each listed country in the selected nominal column. Two columns are used for the analysis: birth date and country.
Information noteRestriction: The nominal correlation analysis is possible only on database columns. You can not use this analysis on file connections.

Defining the nominal correlation analysis

Procedure

  1. In the DQ repository tree view, expand Data Profiling and right-click Analyses > New analysis.
    Contextual menu of the Analyses node.
    The Create new analysis wizard opens.
  2. Select Correlation > Nominal Correlation Analysis and click Create.
  3. In the Name field, enter a name for the current analysis.
    Information noteImportant:

    Do not use the following special characters in the item names: ~ ! ` # ^ * & \\ / ? : ; \ , . ( ) ¥ ' " « » < >

    These characters are all replaced with "_" in the file system and you may end up creating duplicate items.

  4. Set the analysis metadata (Purpose, Description and Author) in the corresponding fields and click Finish.
    A node for the newly created analysis is listed under Analysis in the DQ repository tree view, and the analysis editor opens on the analysis metadata.

Selecting the columns you want to analyze

Procedure

  1. In the analysis editor and from the Connection list, select the database connection on which to run the analysis.
    The nominal correlation analysis is possible only on database columns for the time being. You can change your database connection by selecting another connection from the Connection list. If the analyzed columns do not exist in the new database connection you want to set, you receive a warning message that enables you to continue or cancel the operation.
  2. From the Connection menu, select the database connection on which to run the analysis.
  3. From the Columns menu, click Select columns.
    If you right-click any of the listed columns and select Show in DQ repository view, the selected column will be automatically located under the corresponding connection in the tree view.
  4. Browse the catalogs/schemas in your database connection to the columns you want to analyze.
    You can filter the table or column lists by typing the desired text in the Table filter or Column filter fields respectively. The lists will show only the tables/columns that correspond to the text you type in.
  5. If needed, set thresholds for some indicators by clicking Settings.
    Overview of the Indicator dialog box.
    The indicators representing the simple statistics are by-default attached to this type of analysis.
  6. From the Advanced settings menu, set a Number of connections per analysis.
    You can set this number according to the database available resources, that is the number of concurrent connections each database can support.
  7. If you want to use context variables, click Open context view.
    Setting context variables allows to filter data and to decide the number of concurrent connections per analysis respectively.
    For more information about contexts and variables, see Using context variables in analyses.
  8. Click Save and run.
    The editor switches to the analysis results.
    For detail explanation of the analysis results, see Exploring the results of the nominal correlation analysis.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here