topic Re: Adding dynamic text to chart titles in QlikView

Adding dynamic text to chart titles

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Is there a way to add dynamic text to a chart title when a user selects more than one value in a list box i.e. if a user selects three regions in a list box how do I display all three regions in the chart title?

Thanks

Re: Adding dynamic text to chart titles

v_petrenko — Fri, 25 Nov 2016 11:55:48 GMT

Hi Greg, put this expression into Title property of the chart (open chart properties with it's context menu):

='Regions: ' & Concat( DISTINCT [Region], ', ' )

Please mark the answer as correct and your question as answered if it helped.

Re: Adding dynamic text to chart titles

Anonymous — Fri, 25 Nov 2016 11:59:07 GMT

Try adding this to the chart title:

=concat(Distinct YourDimension,', ')

Regards,

Gabriel

Re: Adding dynamic text to chart titles

Anonymous — Fri, 25 Nov 2016 12:00:20 GMT

Thanks Vasily. That worked. But is there a way to get the list of regions to span more than one line in the chart. It is trying to list them all on one line and there isn't enough room.

Greg

Re: Adding dynamic text to chart titles

deepak_km9886 — Fri, 25 Nov 2016 12:04:23 GMT

Go to your sheet appearance and title section then add this expression manually

='Selected Region: ' & Concat(Distinct [Region Dimension],',')

Re: Adding dynamic text to chart titles

sunny_talwar — Fri, 25 Nov 2016 12:06:45 GMT

You can try this:

='Regions: ' & Concat( DISTINCT [Region], Chr(10))

Re: Adding dynamic text to chart titles

Anonymous — Fri, 25 Nov 2016 12:10:01 GMT

I just added a return as follows and it put each region on a separate line -

='Regions: ' & Concat( DISTINCT [Region], ',

' )

Re: Adding dynamic text to chart titles

sunny_talwar — Fri, 25 Nov 2016 12:12:05 GMT

Sure that is an option as well