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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Auto Populate Chart Title from ListBox field

Hi fellow Qlik Community,

Not sure if this is doable..but lets see how far we can get to the solution.


Question

Is there a way to automatically display the Chart Title, based on the ListBox field I selected?

As an example, I have a field "BMW" in a ListBox. I have a chart created as well to display the number of cars sold from Jan to Dec. So, when I select the "BMW" from the ListBox, the word "BMW" will automatically be populated into the Chart Title.

Any suggestions is highly appreciated!

Thanks very much,

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Say your field is CAR and one value is 'BMW'. If you want to see this selected value in the title, simply put the field name i.e =CAR in the title setting field

View solution in original post

9 Replies
tresesco
MVP
MVP

Say your field is CAR and one value is 'BMW'. If you want to see this selected value in the title, simply put the field name i.e =CAR in the title setting field

Not applicable
Author

This is very good. I got the List Box field populated into the Chart Title.

One last thing, i would also like to concatenate the word "BMW" to be like below on the chart title:

Total Number of "BMW" - July 2012 - July 2013

Not applicable
Author

This is very good. I got the List Box field populated into the Chart Title.

One last thing, i would also like to concatenate the word "BMW" to be like below on the chart title:

Total Number of "BMW" - July 2012 - July 2013

Not applicable
Author

This is very good. I got the List Box field populated into the Chart Title.

One last thing, i would also like to concatenate the word "BMW" to be like below on the chart title:

Total Number of "BMW" - July 2012 - July 2013

Not applicable
Author

Hi,

You should be able to this in your title by using =Car & ' - July 2012 - July 2013'

Cheers,

CG

tresesco
MVP
MVP

try this:

= 'Your Desired text' & CAR & AnotherField

Note: '&' is concatenation character. a text has to be within single quotes and no quotes are required for field.

Not applicable
Author

All is good. Thank you very much !!

Not applicable
Author

Thank you very much clevergoat!

This works perfectly ☺

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

eWindow Helpline

ewindow@platts.com<mailto:ewindow@platts.com>

+65 6530.6530 Singapore

+44 20 7176.6333 London

+1 713 655.2222 Houston

Not applicable
Author

Thank you very much. This works perfectly ☺

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

eWindow Helpline

ewindow@platts.com<mailto:ewindow@platts.com>

+65 6530.6530 Singapore

+44 20 7176.6333 London

+1 713 655.2222 Houston