Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (1)
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.