Discussion board where members can get started with QlikView.
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..
You need to use the name of the cycle group:
Thanks for reply, But it won't work.
So that, I have written the script like this =aggr(sum(Invoice.Qty),GetCurrentField(cgChart2)) even this also isn't work
Please refer the below link:
What's your group name??
Hope it helps
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.......
Try like this
It might be a little to late for you but you have to use this brackets [ ]
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 !!
Hope it helps.
Mayil is right,
important is to use the $-sign.
Then it works.
This works but how do you get the label of the field in the cyclic group?