How to create a dynamic chart title

[Anonymous]

I want to create a chart title that dynamically changes as per the selection

I am new to QV and have gone through the existing blogs for it. but I am unable to figure out where in Chart do i need to getcurrentselection(). Can somebody please assist with the syntax and where do i need to add this in chart with the screenshots

[datanibbler · Accepted solution]

Hi,

on the tab "General" of the dialog of the chart, you have the edit_field "Title" (the topmost one)

=> Just click on the little button next to it (with the "...") and you have the formula_editor open

=> Just insert an IF() construct with the Getfieldselections() function - with the fieldname inside the brackets. That function will return the exact value (or text or whatever) that is currently selected, so you can query it.

=> Ex.: >> = IF(Getfieldselections([partnercode]) = 'spongebob', 'chart_squarepants', 'other chart) <<

(that is for only two possible alternatives. You can of course enter more by nesting several IF_constructs or using a PICK(MATCH()) function.

HTH

[Anonymous]

Hi

When i click on Windows Title little box (...) in the General Tab of the chart i.e the first box if condition doesnt get highligted. Am I doing something incorrect?

[Anonymous]

Adding screenshot

[Anonymous]

adding screenshot

[Anonymous]

Hi

It worked.i did not add '=' sign.