Skip to main content

Customizing fields and groups

ON THIS PAGE

Customizing fields and groups

The next step to customizing your logical model is to define your fields and groups. Fields and groups are the basic level of the logical model. All other logical model elements use these groups.

When you enable a custom logical model, Qlik Sense automatically creates default groups from your data model. It also sets the properties of all your fields. Some of these groups and field properties need to be adjusted. Qlik Sense will make a best interpretation of your data model, but it is not always correct in which fields should be hidden or which fields are measure, for example.

There are three kinds of groups:

  • Dimension: A dimension group consists of related fields that are classified as dimensions. Dimension groups can also contain fields classified as measures or dates.

  • Measure: A measure group consists of related measure fields. Only measures can belong to a measure group.

  • Calendar: A calendar group contains a time dimension in your logical model. Calendar groups can only contain dimensions and must have at least one temporal fields (such as date, timestamp, or year).

Within each group are fields with four properties:

  • Visibility: Defines if a field is visible or not in Insight Advisor. Hidden fields can still be used in analysis, such as when a user searches for that field.

  • Classification: Defines the default role the field plays in analysis. Classifications can be broad, such as dimension, or specific, such as city.

  • Data value lookup: Controls whether or not uses can search for specific values from this field. Reducing the number of fields that have data value lookup enabled can help you avoid false positive results and reduce the query time.

  • Default aggregation: Sets the standard aggregation for measures in Insight Advisor. When a field has a default aggregation, Insight Advisor always applies that aggregation when using it as a measure. Users can edit Insights charts to change the aggregation to a different type in Insight Advisor.

Fields can be ungrouped. Ungrouped fields belong to no group and are excluded from analysis.

Why define fields and groups?

Defining fields and groups enables you to set the defaults of how fields and master items are handled. When you define fields, you set the preferences on how they are handled by Insight Advisor. For example:

  • Should this field be available for analysis in Insight Advisor?

  • Should this field be used as a dimension or measure? What kind of dimension or measure?

  • Can Insight Advisor look up individual values from the field in searches?

  • What should the default aggregation for the field be when used as a measure?

When you define groups, you show Insight Advisor which fields are closely related and should be used together in analysis. Groups are used to create other business logic features, such as packages, calendar periods, and behaviors.

Customizing your fields and groups

You are going to start by cleaning up some of the field properties to change visibility and adjust a few classifications. You are then going to ungroup some of the fields from the groups. With these fields, you will make the following new groups:

  • Customer

  • SalesCity

  • SalesCountry

  • Order date

  • SupportCalls

  • SupportDate

Some fields you will leave ungrouped. Ungrouped fields are not used by Insight Advisor in any analysis. This will remove fields that are not relevant to analysis, such as ID and GeoInfo fields

Customizing field properties

  1. Navigate to Fields & groups.

  2. In Employees, adjust the following fields:

    • For Extension, set the following properties:

      • Visibility: visible
      • Classification: dimension

      • Data value lookup: No

      • Default aggregation: Not specified

    • For EmployeeName, set the following properties:

      • Visibility: visible

      • Classification: dimension

      • Data value lookup: Yes

      • Default aggregation: Not specified

    • For Hire Date, set the following properties:

      • Visibility: visible

    • For Reports To, set the following properties:

      • Visibility: hidden

      • Classification: dimension

      • Data value lookup: Yes

      • Default aggregation: Not specified

    • For Title , set the following properties:

      • Visibility: visible

    • For Year Salary, set the following properties:

      • Visibility: visible

      • Classification: monetary

      • Data value lookup: No

      • Default aggregation: Sum

Ungrouping fields

  1. In Categories, select CatID-CategoryID.

  2. In Suppliers, select SupplierID .

  3. In SupportCalls, select the following:

    • SupportCalls

    • AverageCallSatisfaction

  4. In Products, select ProductID.

  5. In Employees, select EmployeeID.

  6. In Sales Data_ENT, select the following fields:

    • Address

    • City

    • ContactName

    • Country

    • CountryCode

    • Customer

    • CustomerID

    • Latitude

    • Longitude

    • Longitude_Latitude

    • OrderDate

    • OrderID

    • Phone

    • PostalCode

    • ShipperID

  7. Click Ungroup.

Creating Customer group

This group will let you group together dimension fields relating to customer information.

  1. Click Create group.

  2. For Group name, enter Customer.

  3. For Group type, select Dimension.

  4. Add the following fields to the group:

    • Address

    • ContactName

    • Customer

    • Phone

    • PostalCode

  5. Click Create.

Creating SalesCity group

This group will let you group together dimension fields relating to city information. You will use this later when making a hierarchy.

  1. Click Create group.

  2. For Group name, enter City.

  3. For Group type, select Dimension.

  4. Add the following fields to the group:

    • City

    • Longitude_Latitude

  5. Click Create.

Creating SalesCountry group

This group will let you group together dimension fields relating to country information. You will use this later when making a hierarchy.

  1. Click Create group.

  2. For Group name, enter Country.

  3. For Group type, select Dimension.

  4. Add the followings fields to the group:

    • Country

    • CountryCode

  5. Click Create.

Creating SupportCalls group

You removed all fields from the previous SupportCalls group as it was classified as a dimension group. You will use the fields to make a measure group.

  1. Click Create group.

  2. For Group name, enter SupportCalls.

  3. For Group type, select Measure.

  4. Add the following fields to the group:

    • AverageCallSatisfaction

    • SupportCalls

  5. Click Create.

Creating SupportDate group

Finally, you will make a calendar group for the Date field from the support calls data.

  1. Click Create group.

  2. For Group name, enter SupportDate.

  3. For Group type, select Calendar.

  4. Add the following fields to the group:

    • Date

  5. Click Create.

Results

Go to Insights in the Analyze tab and look at the Assets panel. There is a significantly reduced number of fields in Assets. The ID fields are no longer there, for example.

Fields in Assets panel in Insights

Insight advisor with business logic applied. The Assets panel has hidden many fields that were not relevant from analysis.

Now, search for what is the profit by employee. This time, instead of EmployeeID, Insight Advisor uses EmployeeName, a more useful field to use as a dimension in visualizations.

Query results for what is the profit by employee

Profit by employee query results. A bar chart showing the sum of Gross Profit by EmployeeName is the matching result. Additional results are displayed. They show a Value table showing gross profit for each employee and a combo chart showing the contribution of employee name to gross profit.