Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
karin_nevo
Contributor III
Contributor III

Get sum for each possible value of dimension in text obnject

Hi,

I want to display the total of each dimension in text object.

For example, if I have the following chart data

Dimension         Count(ID)

A                             10

B                             12

C                             20

I want to display it in text object as follows:

A: 10, B: 12, C: 20

Of course, the dimension values is not constant and can also change based on user selections.

I tried to use concat and AGGR function with no success.

thanks,

Karin

1 Solution

Accepted Solutions
sunny_talwar

Something like this

Concat(Aggr(Dimension  & ': ' & Count(ID), Dimension), ', ')

 

View solution in original post

2 Replies
sunny_talwar

Something like this

Concat(Aggr(Dimension  & ': ' & Count(ID), Dimension), ', ')

 

karin_nevo
Contributor III
Contributor III
Author

it works. thank for your help!