Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ZoeM
Specialist
Specialist

Concat and Count in a chart dimension

Hello community.

I have attached a sample dashboard where I am trying to create a calculated dimension that summarizes the available data based on what the user clicks in the City list box.

The result I am looking for is in the text box below, how can I do this as a dynamic dimension field? 

 

Thanks in advance. 

Labels (3)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

=GetFieldSelections(City, ', ') & ' has ' &Count(Name)& ' first name people which include ' &count({<occupation={analyst}, Type={First}>}occupation)&' analysts and '&count({<occupation={doctor}>}occupation)& ' doctors'

View solution in original post

2 Replies
Lisa_P
Employee
Employee

=GetFieldSelections(City, ', ') & ' has ' &Count(Name)& ' first name people which include ' &count({<occupation={analyst}, Type={First}>}occupation)&' analysts and '&count({<occupation={doctor}>}occupation)& ' doctors'

ZoeM
Specialist
Specialist
Author

Thanks Lisa_P for the quick TAT.