Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Jesh19
Creator II
Creator II

GetCurrentField() is not working

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

1 Solution

Accepted Solutions
sunny_talwar

So, there is space after Group? Try to remove it and then see if it works

View solution in original post

12 Replies
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
Creator II
Creator II
Author

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])

Capture.PNG

Jesh19
Creator II
Creator II
Author

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

getcurrentfield error.png

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?

Capture.PNG

Jesh19
Creator II
Creator II
Author

Please find additional screenshots for your reference.

getcurrentfield error_1.png

getcurrentfield error_2.png

Thanks & Regards,

Jesh

Jesh19
Creator II
Creator II
Author

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

Capture.PNG

And the GetCurrentField() stopped working