topic How to make Chart Title dynamic based on group selection in QlikView

How to make Chart Title dynamic based on group selection

Mon, 24 Jan 2011 14:20:54 GMT

hi,

I have created a group within a dimension in chart properties, I have 5 different selections that the user can

choose to change the dimensions.

I would like the chart title to change according to the user selected dimension(1 of the 5 choices) from within the group.

How do i do this ?

TIA

How to make Chart Title dynamic based on group selection

Mon, 24 Jan 2011 14:37:27 GMT

Hi,

use

=GetCurrentField([group name])

Good luck!

Rainer

How to make Chart Title dynamic based on group selection

lironbaram — Mon, 24 Jan 2011 14:41:34 GMT

in the title

put the formula getcurrentfield(YourGroupName)

How to make Chart Title dynamic based on group selection

Mon, 24 Jan 2011 14:42:00 GMT

Hi in chart properties write in window title

= ' YOUT TITLE ' & yourdimension

How to make Chart Title dynamic based on group selection

Mon, 24 Jan 2011 14:55:11 GMT

I am putting what you suggested:

=GetCurrentField([group name])

in the expression after I click "show title in chart".

I could not find the group I created from within the Edit expression/Fields/Field

Please advise

How to make Chart Title dynamic based on group selection

Mon, 24 Jan 2011 14:58:41 GMT

Actually I want the TITLE to be in the General Tab/ Window Title.

But either way in the expression I am not able to find the Group I created so I can select that in

the expression you suggested

How to make Chart Title dynamic based on group selection

Mon, 24 Jan 2011 15:06:51 GMT

How do I put a static string field before the expression you gave me.

example: FY09 Chart for: GROUP NAME EXPRESSION THAT YOU GAVE ME.

(btw, the expression works.)

How to make Chart Title dynamic based on group selection

Mon, 24 Jan 2011 15:57:45 GMT

Hi,

type your group name into the brackets like

=GetCurrentField([TimeDrill])

as example.

Add text do the following: ='Your text: ' &GetCurrentField([TimeDrill]

Hope it helps.

Rainer

How to make Chart Title dynamic based on group selection

Mon, 24 Jan 2011 16:14:02 GMT

THANK YOU

Re: How to make Chart Title dynamic based on group selection

Anonymous — Tue, 24 Feb 2015 21:59:51 GMT

Hey Rainer

your answer has been helpful, however I'm still having a small issue, where I've edited the Label of the fields in the Group settings. ie original field name "Charge_cust", and i edited the label to "customer"..

when executing the code as per example, it displays the original field name instead of the edited label name.

else where int he chart is displaying the edited label name.

any pointers would be great.

Thanks.

Bon.

Re: How to make Chart Title dynamic based on group selection

Mon, 16 Mar 2015 01:58:29 GMT

Hi Vijaydop and All,

I have similar issues but looking at the answers, I don't understand how to change the title dynamically with the expressions created in the expression tab. It's not a dimension thus I don't have a group name for it. It seems I can't give them a group name neither.

Anyone can help on this?

Or Vijaydop, you have worked out this?

Thanks.

Re: How to make Chart Title dynamic based on group selection

Anonymous — Mon, 16 Mar 2015 04:51:13 GMT

Hi,

Use the following expression

getcurrentfield(YourGroupName)

Re: How to make Chart Title dynamic based on group selection

Tue, 17 Mar 2015 02:40:41 GMT

Hi Amarnath,

How to make the Group name in expression tab? I have group the below 30to60DPD and 60to90DPD together but I don't have a group name for them. they are not under the dimension tab. Thanks.

Re: How to make Chart Title dynamic based on group selection

danosoft — Thu, 19 Oct 2017 10:30:20 GMT

but GetCurrentField([grouponame]) take me the name of the Column of my group... but if i want show the LABEL?

Re: How to make Chart Title dynamic based on group selection

jim_chan — Wed, 26 Dec 2018 03:49:03 GMT

hi there,

did anyone help you solved your issue?

Rgds

Jim