Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
ganderson100
Contributor

Adding dynamic text to chart titles

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Adding dynamic text to chart titles

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.

View solution in original post

7 Replies
Partner
Partner

Re: Adding dynamic text to chart titles

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.

View solution in original post

Highlighted
gabriel_kirst
Contributor III

Re: Adding dynamic text to chart titles

Try adding this to the chart title:

=concat(Distinct YourDimension,', ')

Regards,

Gabriel

ganderson100
Contributor

Re: Adding dynamic text to chart titles

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

deepak_km9886
Contributor

Re: Adding dynamic text to chart titles

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

You can try this:

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

ganderson100
Contributor

Re: Adding dynamic text to chart titles

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

Sure that is an option as well