Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
cloud
New Contributor III

Concat on Pivot Table doesn't work

Hi experts, 

I have this data:

Type of BreachTypeCountMonth
BreachARed1Feb-19
BreachARed1Mar-19
BreachARed1Mar-19
BreachARed1Mar-19
BreachAAmber1Mar-19

 

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

Type of BreachFeb-19Mar-19
BreachARed-1Amber-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 BreachFeb-19Mar-19
BreachARed1Amber1

 

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

Labels (4)
1 Solution

Accepted Solutions
Partner
Partner

Re: Concat on Pivot Table doesn't work

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

22.PNG

 

1 Reply
Partner
Partner

Re: Concat on Pivot Table doesn't work

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

22.PNG