topic Re: Qlik Sense Grouping dimension values in App Development

Qlik Sense Grouping dimension values

tommyl — Sat, 16 Nov 2024 20:11:47 GMT

Hello experts,

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

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

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 — Tue, 27 Aug 2019 08:53:05 GMT

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

tommyl — Tue, 27 Aug 2019 10:02:07 GMT

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