GetCurrentField() is not working

[Jesh19]

Hi All,

I'm having a cyclic group dimension.

Sales Channel Group - (DimSalesCluster_NoSM, DimSalesRegion_NoSM, DimSalesCountry_NoSM, DimSalesBranch_NoSM, DimSales_Person) which are labelled as (Cluster, Region, Country, Branch, Sales Person) respectively.

Now, when I'm trying to get the current field from Cyclic Group, it's showing me null.

I've tried all the below expressions,

=GetCurrentField ([Sales Channel Group]) // NULL

=GetCurrentField ('[Sales Channel Group]') // NULL

=$(=GetCurrentField ([Sales Channel Group])) // NULL

=$(=GetCurrentField ('[Sales Channel Group]')) // NULL

Could someone please do the needful.

Thanking in Advance,

Regards,

Jesh

[sunny_talwar]

Would you be able to share a sample where we can see the issue? Also, this is QlikView, right? Because GetCurrentField doesn't work in Qlik Sense

[Jesh19]

Hi Sunny,

I have attached Sample File for your reference.

You can see the Caption of Straight table and text object.

Yeah, the issue is in QV.

Thanks & Regards,

Jesh

[sunny_talwar]

Without single quotes is working, isn't it?

=GetCurrentField([Sales Channel Group])

[Jesh19]

In the sample which I've shared you, it's working without quotes.

But in the actual file which we publish onto Access Point, it's neither working with nor without quotes.

As I mentioned earlier, I've tried all the 4 expressions. But of no use.

Attached the screenshot for your reference

Thanks & Regards,

Jesh

[sunny_talwar]

Hahahaha, no point of sharing a sample where the expression is working as I won't be able the see the issue. Are you sure you are typing the name of the group correctly? hope you are not missing any white spaces and taking care of the upper and lower cases as QlikView is case sensitive where Hello is different then hello.

[sunny_talwar]

Any extra spaces here? What is the expression in the text box object?

[Jesh19]

Please find additional screenshots for your reference.

Thanks & Regards,

Jesh

[Jesh19]

Yes, there's an extra space. I've tried it removing the extra space. Still the same issue

The text box expression is with quotes.

[sunny_talwar]

In the image you can't really see, but I added an extra space at the end after group

And the GetCurrentField() stopped working