Document Properties - Groups in QliView

This article provieds an Introduction to Groups In QlikView applications.

This article provieds an Introduction to Groups In QlikView applications.

Document properties of QlikView document

There are various document properties of a QlikView document. Then go to Settings -> Document properties.

property

Now I introduce what Groups are in QlikView document properties.

group tab

Introduction to Groups

In Groups, it is possible to create a drill down or cyclic field group. A list shows all groups in the document. An icon to the left of each group name indicates whether it is a drill-down group or a cyclic group. A group can be selected by clicking in the list. The selected groups are shown in the Used Fields area.

There are two types of groups.

  • Hierarchic Groups (Drill-Down)
  • Non-Hierarchic Groups (Cyclic)

Hierarchic Groups (Drill-Down)

The drill down groups are always known as "Hierarchic Groups". The chart is used to drill down the group as a dimension. In the group's list fields that has more than one possible value. When only one field is selected from groups, then it has only one possible value. If there is no field in the list, then it has more than one possible value and the last field will be used anyway.

Example

Fruits: Mango, Banana, Orange

Non-Hierarchic Groups (Cyclic)

Cyclic dimension groups are made up of a number of fields. A Cyclic group is part of the chart expression. If you want to see a cyclic group then go to Chart Properties -> Expression.

Manage Group settings

If you want to manage group settings then select the "New" button in the groups tab.

new

Now you will see the group settings window. In this window you can create a new group, select a group type and manage the group settings.

group

Now you can manage these group settings.

Group Name: In this group setting, we need to enter a name for the group and select  group type also either Drill-down Group or Cyclic Group.

Available Fields: In this settings, the available fields are available in the column.  Here we can select the fields to include in the group.

Show Fields from Table: Here we can select a table.

Add: In this setting, we move the selected fields from the available fields to the column of used fields.

Add All: Here we move all the fields from the column of available fields to the column of used fields.

Remove: Here we move the selected fields listed in the column of used fields to the column of available fields.

Promote: Here we move the selected field one step further up in the list of used Fields.

Demote: Here we moves the selected field one step further down in the list of used fields.

Used Fields: These types of fields are included in the current group are listed in this column. By default  the column is empty.

Add Expression: Opens the edit expression dialog for easy editing of long formulas.

Edit: Opens the Edit Expression dialog for editing the selected formula in the used fields area.

Label: An alternative name for the displayed field can be entered here. It will be used as dimension name in the chart. The label may be defined as a Calculated Formula for dynamic update.

Sort Orders: Clicking on this button opens the Group Sort Order dialog in which a separate sort order can be set for each field in the group.

Summary

This article provided an introduction to groups in QlikView and also described what groups are and also how to manage group settings in document properties.