topic Re: Group Lable in QlikView

Group Lable

adiarnon — Sun, 26 Oct 2014 07:06:35 GMT

hi,

i have a group (cycle) wnd i gave lable to the fields in the group.

i created a text box with the expression-

GetCurrentField(Emp_Cyc)&' (Working Hours)'

the function GetCurrentField gives me the name of the field (Not the label i gave him)

how can i change the expression to see the label of the field in the group and not the real name??

tnx,

adi

Re: Group Lable

ecolomer — Sun, 26 Oct 2014 08:22:05 GMT

I think this is not possible

Re: Group Lable

Sun, 26 Oct 2014 08:57:38 GMT

No not possible in my opinion. Maybe other experts can suggest.

Re: Group Lable

Kushal_Chawda — Sun, 26 Oct 2014 09:29:11 GMT

Instead of giving label ,rename the field in back end with the name you want to display.

Re: Group Lable

adiarnon — Sun, 26 Oct 2014 10:57:54 GMT

i dont want to change the name of the field.

Re: Group Lable

adiarnon — Tue, 28 Oct 2014 06:51:43 GMT

somepne have a solution or should i give up?

Re: Group Lable

jagan — Tue, 28 Oct 2014 07:08:57 GMT

Hi,

You can try like this

=Pick(Match(GetCurrentField(GroupName), 'Dimension1', 'Dimension2', 'Dimension3'), 'Dim1 Caption', 'Dim 2 Caption', 'Dim 3 Caption') &' (Working Hours)'

Hope this helps you.

Regards,

Jagan.

Re: Group Lable

Anonymous — Tue, 28 Oct 2014 07:30:41 GMT

Hi,

If you don't want to do it in layout, you can try to create an isolate table containig the inicial and final label. I mean:

name1 name2

Dim1 Dim1 Caption

Dim2 Dim2 Caption

Dim3 Dim3 Caption

And then in the objects:

=only(p({<name1={"$(=GetCurrentField(GroupName))"}>} name2))

Hope it helps.

Marc.

Re: Group Lable

Anonymous — Tue, 28 Oct 2014 07:31:28 GMT

Jagan Mohan's trick works