topic Re: How to get the Field Name form Cyclic Group? in QlikView

How to get the Field Name form Cyclic Group?

Tue, 23 Oct 2012 07:18:17 GMT

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.

Re: How to get the Field Name form Cyclic Group?

Gysbert_Wassenaar — Tue, 23 Oct 2012 08:03:45 GMT

You need to use the name of the cycle group:

=GetCurrentField("GroupName")

Re: How to get the Field Name form Cyclic Group?

Tue, 23 Oct 2012 08:38:21 GMT

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

Re: How to get the Field Name form Cyclic Group?

MayilVahanan — Tue, 23 Oct 2012 09:01:10 GMT

Please refer the below link:

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

What's your group name??

Hope it helps

Re: How to get the Field Name form Cyclic Group?

Tue, 23 Oct 2012 14:02:41 GMT

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.

Re: How to get the Field Name form Cyclic Group?

MayilVahanan — Tue, 23 Oct 2012 14:11:29 GMT

Try like this

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

Hope it helps

Re: How to get the Field Name form Cyclic Group?

Mon, 02 Sep 2013 07:09:18 GMT

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

Re: How to get the Field Name form Cyclic Group?

senpradip007 — Mon, 02 Sep 2013 07:16:24 GMT

Hi,

Try this

=GetCurrentField(GroupName)

Hope it helps.

Re: How to get the Field Name form Cyclic Group?

berndjaegle — Wed, 25 Jan 2017 14:31:19 GMT

Mayil is right,

important is to use the $-sign.

$(=GetCurrentField(cgChart1))

Then it works.

Re: How to get the Field Name form Cyclic Group?

carlcimino — Thu, 01 Nov 2018 15:34:48 GMT

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

Re: How to get the Field Name form Cyclic Group?

carlcimino — Thu, 01 Nov 2018 17:06:43 GMT

Solved by using an if statement after seeing the response below by s.florian. Not elegant and it does give the squiggly lines but it works...