Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

You need to use the name of the cycle group:

=GetCurrentField("GroupName")


talk is cheap, supply exceeds demand
Not applicable
Author

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

Thanks & Regards,
Mayil Vahanan R
Not applicable
Author

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

Thanks & Regards,
Mayil Vahanan R
Not applicable
Author

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
Specialist III
Specialist III

Hi,

Try this

=GetCurrentField(GroupName)

Hope it helps.

berndjaegle
Creator II
Creator II

Mayil is right,

important is to use the $-sign.

$(=GetCurrentField(cgChart1))

Then it works.

carlcimino
Creator II
Creator II

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