Concat on Pivot Table doesn't work

cloud — Sat, 16 Nov 2024 03:22:18 GMT

Hi experts,

I have this data:

I would like to display this in pivot table with set expression/analysis as shown below:

Type of Breach	Feb-19	Mar-19
BreachA	Red-1	Amber-1, Red-3

I tried this expression but it doesn't work for some reason:

Concat(Aggr(DISTINCT MaxString(Type) & Count(Count), Type), ', ')

Currently it shows me this:

Type of Breach	Feb-19	Mar-19
BreachA	Red1	Amber1

Appreciate any help that I can get. Type in example instead of sharing Qlikview files as I can't open it. Thank you.

Re: Concat on Pivot Table doesn't work

NZFei — Fri, 07 Jun 2019 02:22:35 GMT

Concat(aggr(Type & '-' & sum(Count), [Type of Breach], Month, Type), ', ')