Skip to main content

Datasets

Datasets are logical collections of sources or entities. Datasets are consistent in structure: Objects instantiate at the entity level when the workflow transits to publish, prepare, or explore.

Qlik Catalog supports on-the-fly creation and curation, publish, transform, and export of project-specific data sources.

Options for Checkout of datasets include:

  • Explore Creates a distribution table view
  • Prepare Transform
  • Publish to a predefined target directory
  • Publish to Qlik Sense
  • Publish to Power BI

Create dataset

From the discover module, select Datasets from the navigation bar. The datasets panel opens displaying the public and private dataset collections that the logged-in user has access to. Select the icon gear view actions (gear) icon for available dataset actions: Create Dataset, Add to Cart, Explore, Prepare, Publish, and Publish to Qlik Sense.

Create dataset

Select gear icon to view action options for selected datasets.

Select Create Dataset after selecting objects to be grouped into a new dataset.

Enter Dataset Name and Description.

Check the box to make the dataset public for assignment to one or more user groups.

Do not check the box if the dataset will be a private working dataset.

Save the dataset.

Public and private datasets

Users can create working sets of data for their own personal working sets or check the box next to public to make the dataset available to users with appropriate access permissions.

Note that role-based access to datasets is granted and edited through security settings. Groups are given access to datasets through entity-level permissions. Therefore, users will be able to create datasets with the objects they have access to. Administrators edit group access to sources (selecting applicable individual entities) within the security module to configure group access and user roles.

To create a dataset grouping select or check desired datasets, Create Dataset from action dropdown, then populate Dataset Name and Description fields, and Save the dataset.

Create a Dataset Grouping

Create a dataset grouping by selecting and staging sources and entities

Adding entities and sources to datasets

  1. Select objects then select Add to Dataset.
  2. Select the appropriate Dataset from drop-down. Save updates by selecting Add to Dataset.
Adding entities and sources to datasets

Add sources or entities to an existing dataset

Create datasets with selected objects

  1. Select objects (Sources or Entities) then Create Dataset.
  2. Enter Dataset Name and Description.
  3. Check the box to make the Dataset Public to those with access permissions.
  4. Save the new Dataset.
Create datasets with selected objects

Create Datasets with Selected Objects

Add datasets to cart

Select Datasets, then Add to Cart.

Add to Cart

Add Datasets to Cart by selecting desired datasets and then "Add to Cart" through action dropdown

Note that the number of datasets that have been added display in My Cart status.

Expand Datasets and/or other Entities and Sources to select specific objects for the desired operation; Select an action from Take Action dropdown.

For the example below, the Explore canvas opens with selected objects extracted to the canvas.

Custom user views can then be created through explore with the new dataset.

Create datasets with selected objects

Stage selected objects to explore distribution view creation