Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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. 

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: Concat and Count in a chart dimension

=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

Re: Concat and Count in a chart dimension

=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

Highlighted
Creator III
Creator III

Re: Concat and Count in a chart dimension

Thanks Lisa_P for the quick TAT.