Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
LesJean
New Contributor III

Categorization in a table

Hello everyone,

So I have data in a table visualization and I'm trying to further categorize it inside "sub-sections". Lets say I currently have my data like this:

 

ID | Description | Sub-group 
1 | aaa | 1
2 | bbb | 1
3 | ccc | 1
4 | ddd | 2
5 | eee | 2
6 | fff | 3
7 | ggg | 3

Is there any way to display my data in this way with Qlik Sense (be it with a table visualization or any other visualization that would enable me to do this) :

 

ID | Description
Sub-group 1
1 | aaa
2 | bbb
3 | ccc
Sub-group 2
4 | ddd
5 | eee
Sub-group 3
6 | fff
7 | ggg

Thank you guys very much,

 

LesJean

 

1 Solution

Accepted Solutions
y_grynechko
New Contributor III

Re: Categorization in a table

Hey, 

One of the solution would be to use pivot:

Przechwytywanie.PNG

1 Reply
y_grynechko
New Contributor III

Re: Categorization in a table

Hey, 

One of the solution would be to use pivot:

Przechwytywanie.PNG