topic Re: Concat and Count in a chart dimension in QlikView

Concat and Count in a chart dimension

ZoeM — Sat, 16 Nov 2024 01:24:46 GMT

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.

Re: Concat and Count in a chart dimension

Lisa_P — Tue, 28 Jan 2020 01:21:23 GMT

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

Re: Concat and Count in a chart dimension

ZoeM — Tue, 28 Jan 2020 14:18:25 GMT

Thanks Lisa_P for the quick TAT.