Is there a way to group labels in Qlik Sense?

Question

So I have data, and I want to count the labels:

Attribute            Labels
A                    Man, kind
B                    Girl, kind
C                    Man, bad
D                    Man
E                    Girl

I already put the data in Qlik Sense and created a pie chart based on labels, resulting in : Man, kind = 1; girl ,kind = 1; man, bad = 1; man = 1; girl = 1

But it isn't the expected result I want. The expected result I want is: Man = 3 , girl = 2, kind =2 , bad = 2. After that I will create a pie chart from the result.

How can I achieve this?

score 2 · Accepted Answer · edited Nov 11 '19 at 20:35

2

You need to use SubField to split Labels per delimiter. You can also add 1 as #number so then is easier do just SUM(#number) in any chart.

You haven't included your code so I tested solution using INLINE load with your data and it is working fine.

[table]:
LOAD
    Attribute,
    SubField(Labels,', ') as Labels,
    1 as #number;
LOAD * INLINE [
    Attribute,     Labels
    A,             "Man, kind"
    B,             "Girl, kind"
    C,             "Man, bad"
    D,             "Man"
    E,             "Girl"
];

result:

edited Nov 11 '19 at 20:35

Stefan Stoichev

4,615
3
31
51

answered Nov 11 '19 at 12:07

Hubert Dudek

1,666
1
13
21

sorry , just get back to work , i will test the code – trytocode Nov 12 '19 at 01:32

Is there a way to group labels in Qlik Sense?

1 Answers1