Having subcategory within table

[contributor_H]

Dear Community,

I have something similar to below table:

Primary Code	Comment	Secondary Code	Details
P1	Good	P1-11	Fast Service
P1	Good	P1-11	Fast Service
P2	Good	P2-12	Clean workshop
P2	Good	P2-13	High Service Quality
N1	Bad	N1-13	Waiting for long
N2	Bad	N2-13	Bad Quality
N1	Bad	N1-13	Waiting for long

I want to group Comment column together and then count them, then have another column that group Details based on the Comment category, the end result will be something as below:

Comment	Total	Detail	Total
Good	4	Fast Service	2
		Clean workshop	1
		High Service Quality	1
Bad	3	Waiting for long	2
		Bad Quality	1

Detail are group based on Comment or Primary Code (or it's sub group)

[JHuis]

Hello,

you need to measures:

for the total:

aggr(Count([Primary Code]),Comment)

second measure:

Count([Secondary Code])

[contributor_H]

Bear with me, I'm new to qlik. These measures will be written in some kind of table or when we load the data?