Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
cloud
Contributor III
Contributor III

Concat Aggr 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. 

 

Labels (4)
2 Replies
ramasaisaksoft

Hi Cloud,

 

we can achieve the result in a different way ,with the help of Pivot table

 

Create a Pivot table,Use

color Dimension, 

Expression:-count(Color)

click ok

Now you need to Drag Dimension into Horizontal(i mean "Color" column as Horizontal manner)hope you already know the concept ,convert column into Horizontal row in pivot table.

then you will get result like my attachment.

123.PNG123.PNG

cloud
Contributor III
Contributor III
Author

Hi, this is not the result I need.
I need to display "Red-3, Amber-1" on a single cell in a pivot table.