Qlik Sense Grouping dimension values

[tommyl]

Hello experts,

I have a question about grouping dimension values.  Here is my data sample:

customer_id	service_type
1	PSTN
1	Data
1	PSTN
3	PSTN
3	PSTN
2	Data
2	Data
4	Data

I want to display the number of customers according to their service type groups like in a treemap chart:

Criteria	Count
Only PSTN	1 (for customer_id= 3)
Only Data	2(for customer_id= 2 and 4)
PSTN and Data	1(customer_id=1)

I created measure expression like:

(aggr(count({<service_type= {'PSTN'}>}service_type),customer_id)). But it is not even close. Could you please help me?

Regards,

[Gysbert_Wassenaar · Accepted solution]

try this:
dimension: =aggr(concat(distinct service_type,' and '),customer_id)
measure: =count(distinct customer_id)

[tommyl]

That's perfect. Instead of customer_id, i wrote service_type in the measure expresion. That is what i needed:) thank you.