Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
cloud
Contributor III
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
NZFei
Partner - Specialist
Partner - Specialist

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

22.PNG

 

View solution in original post

1 Reply
NZFei
Partner - Specialist
Partner - Specialist

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

22.PNG