Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Brip51
Creator
Creator

Format Dynamic Chart Title

Hi,

I have a chart title based on selected fields like so-

='_ Equipment Type is '&GetFieldSelections (EqpType)&'_ Activity Month is '&GetFieldSelections (ActivityMonth)

My output is 

_ Equipment Type is Truck _Activity Month is May.

  I am trying to format the title so I can space out the selected fields so they will be more readable, but if I put spaces in the '' the don't appear in the title.  I want the title to look like-

Equipment Type is Truck              Activity Month is May

I am not sure what I am missing.  Any help would be appreciated.

Thanks

Brian

 

1 Reply
treysmithdev
Partner Ambassador
Partner Ambassador

I believe what you want to do is add spaces to the value separator in GetFieldSelections. You can do this by doing: 

='_ Equipment Type is '&GetFieldSelections (EqpType, ',  ')&'_ Activity Month is '&GetFieldSelections (ActivityMonth ',  ')

 

 

Blog: WhereClause   Twitter: @treysmithdev