topic How to create a dynamic chart title in QlikView

How to create a dynamic chart title

Anonymous — Tue, 21 Apr 2015 09:01:08 GMT

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

Re: How to create a dynamic chart title

datanibbler — Tue, 21 Apr 2015 09:07:04 GMT

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

Re: How to create a dynamic chart title

Anonymous — Tue, 21 Apr 2015 09:20:25 GMT

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?

Re: How to create a dynamic chart title

Anonymous — Tue, 21 Apr 2015 09:22:27 GMT

Adding screenshot

Re: How to create a dynamic chart title

Anonymous — Tue, 21 Apr 2015 09:23:23 GMT

adding screenshot

Re: How to create a dynamic chart title

Anonymous — Tue, 21 Apr 2015 10:43:44 GMT

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