Discussion Board for collaboration related to Creating Analytics for QlikView.
I have this data:
I would like to display this in pivot table with set expression/analysis as shown below:
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:
Appreciate any help that I can get. Type in example instead of sharing Qlikview files as I can't open it. Thank you.
Concat(aggr(Type & '-' & sum(Count), [Type of Breach], Month, Type), ', ')
View solution in original post