Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I have this data:
Type of Breach | Type | Count | Month |
BreachA | Red | 1 | Feb-19 |
BreachA | Red | 1 | Mar-19 |
BreachA | Red | 1 | Mar-19 |
BreachA | Red | 1 | Mar-19 |
BreachA | Amber | 1 | Mar-19 |
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.
Concat(aggr(Type & '-' & sum(Count), [Type of Breach], Month, Type), ', ')
Concat(aggr(Type & '-' & sum(Count), [Type of Breach], Month, Type), ', ')