topic GetCurrentField() is not working in QlikView

GetCurrentField() is not working

Jesh19 — Mon, 11 Jun 2018 17:06:09 GMT

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

Re: GetCurrentField() is not working

sunny_talwar — Mon, 11 Jun 2018 17:16:38 GMT

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

Re: GetCurrentField() is not working

Jesh19 — Mon, 11 Jun 2018 17:26:42 GMT

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

Re: GetCurrentField() is not working

sunny_talwar — Mon, 11 Jun 2018 17:37:48 GMT

Without single quotes is working, isn't it?

=GetCurrentField([Sales Channel Group])

Re: GetCurrentField() is not working

Jesh19 — Mon, 11 Jun 2018 17:41:14 GMT

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

Re: GetCurrentField() is not working

sunny_talwar — Mon, 11 Jun 2018 17:48:19 GMT

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.

Re: GetCurrentField() is not working

sunny_talwar — Mon, 11 Jun 2018 17:49:43 GMT

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

Re: GetCurrentField() is not working

Jesh19 — Mon, 11 Jun 2018 17:53:47 GMT

Please find additional screenshots for your reference.

Thanks & Regards,

Jesh

Re: GetCurrentField() is not working

Jesh19 — Mon, 11 Jun 2018 17:56:23 GMT

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.

Re: GetCurrentField() is not working

sunny_talwar — Mon, 11 Jun 2018 17:57:16 GMT

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

And the GetCurrentField() stopped working

Re: GetCurrentField() is not working

sunny_talwar — Mon, 11 Jun 2018 17:58:01 GMT

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

Re: GetCurrentField() is not working

Jesh19 — Mon, 11 Jun 2018 18:01:59 GMT

The issue is because of the space. There are 3 whitespaces after group name. I've removed them and tried the same.

It's working now.

Thanks a lot for your help Sunny.

Regards,

Jesh

Re: GetCurrentField() is not working

sunny_talwar — Mon, 11 Jun 2018 18:04:06 GMT

Hahahaha, if I may ask... what was the reason for the extra spaces in the first place? and in general I would try to copy the same thing I have used in my actual file so that you can replicate the issue in a sample. Because you were using A, but showed me B... it took us more than usual to solve a very simple problem.

Anyways, I am glad we are behind it now.

Best,

Sunny