Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to get the Field Name form Cyclic Group?

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.

10 Replies

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

You need to use the name of the cycle group:

=GetCurrentField("GroupName")


talk is cheap, supply exceeds demand
Not applicable

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

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?

HI

Please refer the below link:

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

What's your group name??

Hope it helps

Not applicable

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

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?

HI

Try like this

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

Hope it helps

Not applicable

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

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
Valued Contributor III

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

Hi,

Try this

=GetCurrentField(GroupName)

Hope it helps.

berndjaegle
Contributor

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

Mayil is right,

important is to use the $-sign.

$(=GetCurrentField(cgChart1))

Then it works.

carlcimino
Contributor

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

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

Community Browser