How to get the Field Name form Cyclic Group?

[#1]

Hi,

I want to know How to get the Field Name form Cyclic Group?

I got a Cyclic Group name from Chart object through this =GetObjectField(1,'CH525') // it returns cgChart2

Now, I want to get the field name form Cyclic Group, So, I wrote the expression like this

=GetCurrentField(GetObjectField(1,'CH525')) // returns null

Here, it need to returns "Customer Name"

But below will returns Correct result

=GetCurrentField(cgChart2) // returns "Customer Name"

=GetCurrentField('cgChart2') // returns null

Thanks in advance..

Regards,

Kabilan K.

[Gysbert_Wassenaar]

You need to use the name of the cycle group:

=GetCurrentField("GroupName")

[#3]

Hi ,

Thanks for reply, But it won't work.

=GetCurrentField(cgChart2) // returns "Customer Name"

=GetCurrentField('cgChart2') // returns null

So that, I have written the script like this =aggr(sum(Invoice.Qty),GetCurrentField(cgChart2)) even this also isn't work

regards,

kabilan K

[MayilVahanan]

HI

Please refer the below link:

http://community.qlik.com/message/212654#212654

What's your group name??

Hope it helps

[#5]

Hi,

This will returns

=GetCurrentField("CgChart1")  // Customer Name

Here, cgChart1 is a Cyclic Group name.

But I am not able to use this expression in to another expression like below

aggr(sum(Invoice.Qty),GetCurrentField("cgChart1")) // returns null

please help me.

Thanks in advance.......

Regards,

Kabilan K.

[MayilVahanan]

HI

Try like this

=aggr(Sum(Sales),$(=GetCurrentField(cgChart1)))

Hope it helps

[#7]

It might be a little to late for you but you have to use this brackets [ ]

Example:

IF (GetCurrentField(    [  CYCLIC  GROUP NAME  ]   )  = ' FIELDNAME ',....

QV will maybe show an Error and won´t display the following code lines correct with colors but it works !!

Greetings

Flo

[senpradip007]

Hi,

Try this

=GetCurrentField(GroupName)

Hope it helps.

[berndjaegle]

Mayil is right,

important is to use the $-sign.

$(=GetCurrentField(cgChart1))

Then it works.

[carlcimino]

This works but how do you get the label of the field in the cyclic group?