topic Re: Cyclic Group Name in QlikView

Cyclic Group Name

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I Have a cyclic group as below:

Group Name : abc

Fields Label

a w

b x

c y

d z

In a textbox, I am using =GetCurrentField(abc) to get the current field of the cyclic group.

But my Requirement is to get the label and not the fieldname.

Is that possible??

Regards,

Anjali Gupta

Re: Cyclic Group Name

Chanty4u — Wed, 20 Apr 2016 06:46:10 GMT

chk dis

Cyclic Group Labels in a text box?

Re: Cyclic Group Name

kaushiknsolanki — Wed, 20 Apr 2016 06:46:57 GMT

Hi,

Yes it is possible.

You can use the same expression in label.

Regards,

Kaushik Solanki

Re: Cyclic Group Name

Wed, 20 Apr 2016 06:53:54 GMT

Hi Chanty,

Thanks for the quick reply. But in the above link. They have changed from cyclic group to drop-down list.

But what I need is cyclic group and not drop-down list.

Re: Cyclic Group Name

vikasmahajan — Wed, 20 Apr 2016 06:54:27 GMT

see this https://community.qlik.com/message/17673#17673

Vikas

Re: Cyclic Group Name

Wed, 20 Apr 2016 06:55:23 GMT

Hi Kaushik,

I didn't get you. Where do you want me to write the expression?

If you can tell me what exactly I have to do then it would be great.

Thanks,

Anjali Gupta

Re: Cyclic Group Name

Chanty4u — Wed, 20 Apr 2016 06:58:32 GMT

did u try this?

you can use =getCurrentField(groupName) to get the current selection in the cyclic group.

For the second, if you select the option "show title in chart" and leave the title blank, it will use the expression label for the expression selected (assuming that this is the first expression).

Re: Cyclic Group Name

Wed, 20 Apr 2016 07:01:20 GMT

Hi Chanty,

If you have read my question, I have mentioned that I have tried that expression. But it is giving me the field Name and not the label associated with that field.

But my requirement is to use the label and not the field name.

Regards,

Anjali Gupta

Re: Cyclic Group Name

Chanty4u — Wed, 20 Apr 2016 07:02:38 GMT

can u share the sample ?

Re: Cyclic Group Name

marcus_sommer — Wed, 20 Apr 2016 07:10:52 GMT

The only solution is to put the label within each group-dimension and extract it from there again. This meant if you used:

Fields Label

a w

b x

c y

d z

you changed the included fields into expressions and put your label as comment:

Fields

= a //w

= b //x

...

and the you extract it with:

subfield(getcurrentfield(abc), '//', 2)

- Marcus

Re: Cyclic Group Name

kaushiknsolanki — Wed, 20 Apr 2016 07:16:28 GMT

Hi Anjali,

I am sorry I didnt saw your question properly.

There is no default function which can get you the label of the field, all you will get is the name of the field.

My suggestion will be that you change the name of the field to the one which you want as label.

Regards,

Kaushik Solanki

Re: Cyclic Group Name

tamilarasu — Wed, 20 Apr 2016 07:24:06 GMT

I guess, there is no direct way to get the label name. Instead, you can use below expression,

=Pick(Match(GetCurrentField(abc) ,'a','b','c','d'),'w','x','y','z')

Re: Cyclic Group Name

Wed, 20 Apr 2016 07:27:17 GMT

Thanks Tamil Nagaraj for the answer.

Regards,

Anjali Gupta

Re: Cyclic Group Name

Wed, 20 Apr 2016 07:28:24 GMT

Thanks Kaushik Solanki for the reply.

Re: Cyclic Group Name

Wed, 20 Apr 2016 07:31:42 GMT

Thanks Marcus,

But i don't want to change my field name.

Regards,

Anjali Gupta