topic Field Value in Chart Title in QlikView

Field Value in Chart Title

Fri, 16 Sep 2011 14:47:34 GMT

Hi,

I want to display name of the Product that I'm selecting in a list box on the title of a chart.

My chart has a dimension Qtr Year ( calculated by Qtr&' '&Year) and a measure Revenue. I select a product and a year and the chart is supposed to show Revenue for the selected Product for all the quarters of the year. I have done that.

Now the Chart Title. Presently it is a static string 'Revenue Summary by Product' I want it to say 'Product X Revenue Summary' where Product X is dynamic and changes based on the selection made in the Product Name list box.

Is it possible to do so?

Field Value in Chart Title

Anonymous — Fri, 16 Sep 2011 14:51:11 GMT

Put your application in order to take a look.

Field Value in Chart Title

Fri, 16 Sep 2011 15:25:26 GMT

You can use the GetFieldSelections function.

Re: Field Value in Chart Title

IAMDV — Fri, 16 Sep 2011 15:39:01 GMT

Amitesh - You can use the below expression.

='Product : ' & GetFieldSelections(Product) & 'Revenue Summary'

I hope this helps!

Cheers - DV

Field Value in Chart Title

Fri, 16 Sep 2011 15:47:50 GMT

Hi DV and ehilsinger,

Thanks to both of you for helping me out. Sorry I could not mark both your answers as correct.

I'm a new to this so DV's complete syntax helped more.

Thanks again for the prompt replies.

Amitesh