topic Re: Cyclic Group - Title chagne too? in QlikView

Cyclic Group - Title chagne too?

knightwriter — Thu, 20 Aug 2015 09:01:35 GMT

Hi All,

I have a cyclic group created and a 'Show Title in Chart' selected in the graph general tab.

Is it possible to change this title once the next cyclic group is selected?

Many thanks.

Re: Cyclic Group - Title chagne too?

alexandros17 — Thu, 20 Aug 2015 09:06:33 GMT

Use the function

getcurrentfield (GroupName)

to do this ....

let me know

Re: Cyclic Group - Title chagne too?

jonathandienst — Thu, 20 Aug 2015 09:17:06 GMT

Are you talking about a cyclic group in the dimensions or cyclic expressions.

For the first, you can use =getCurrentField(groupName) to get the current selection in the cyclic group.

For the second, if you select the option "show title in chart" and leave the title blank, it will use the expression label for the expression selected (assuming that this is the first expression).

Re: Cyclic Group - Title chagne too?

knightwriter — Thu, 20 Aug 2015 09:38:04 GMT

Thats great, I've got this partially working so thank you for that.

Stupid question but my (groupname) is 'activity group' and I either get : or Error in expression as a result. What am I doing wrong?

Re: Cyclic Group - Title chagne too?

knightwriter — Thu, 20 Aug 2015 09:39:17 GMT

Hi jonathan,

I am using the cyclic group in dimensions.

Thanks for the tip for expression use.

Re: Cyclic Group - Title chagne too?

knightwriter — Thu, 20 Aug 2015 09:56:02 GMT

crisis adverted I did not use [] so, [activity group] is the correct result.

Thanks again.

Re: Cyclic Group - Title chagne too?

knightwriter — Thu, 20 Aug 2015 11:56:01 GMT

Hi Alessandro / jonathan,

The group name being pulled is the expression in the group (as expected) but is it possible to change the group name so the displayed getselectionfield is legible?

I have edited the label in in edit groups but this only changes in the cyclic icon.