Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted
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
Highlighted
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

Creator III
Creator III

Thanks Lisa_P for the quick TAT.