topic Cyclic Group Labels in a text box? in QlikView

Cyclic Group Labels in a text box?

Wed, 23 Mar 2011 11:38:11 GMT

Hi,

Does anyone know if its possible to return the active "cyclic group" label in a separate text box?

Please advise,

Kind regards,

Rich

nb am using QV v8.5

Cyclic Group Labels in a text box?

pat_agen — Wed, 23 Mar 2011 11:46:11 GMT

Hi Rob,

try getcurrentfield( myGroup )

Cyclic Group Labels in a text box?

Wed, 23 Mar 2011 11:49:25 GMT

You can try

=GetCurrentField(GrupName)

Regards

Anders

Cyclic Group Labels in a text box?

Wed, 23 Mar 2011 12:01:17 GMT

=GetCurrentField(GrupName)

Cyclic Group Labels in a text box?

Wed, 23 Mar 2011 12:01:49 GMT

Hi both,

Thanks for your replies! I forgot to say that the cyclic group is a pair of expressions, where I was not required to define a name when creating this group.

When creating a "cyclic group" dimension, I can see the option to define the name, although cannot when used as an expression. Is it possible?

Please advise,

Kind regards,

Rich

Cyclic Group Labels in a text box?

pat_agen — Wed, 23 Mar 2011 12:35:35 GMT

Rob,

it's not really a cyclic group. you have just grouped two expressions. One way around this is if your expressions are very similar ie sum(value), sum(qtykg), the you can use a variable like this:

sum($(myVar))

myVar can either take the value "value" or "qtykg". It can then be used in the expressionand elsewhere in a text box. Your expression will no longer be grouped and users wil have to toggle the variable rather than click on the cyclic icon.