Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

Group Lable

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

1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

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.

View solution in original post

8 Replies
ecolomer
Master II
Master II

I think this is not possible

Not applicable

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

Kushal_Chawda

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

adiarnon
Creator III
Creator III
Author

i dont want to change the name of the field.

adiarnon
Creator III
Creator III
Author

somepne have a solution or should i give up?

jagan
Partner - Champion III
Partner - Champion III

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.

Anonymous
Not applicable

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.

Anonymous
Not applicable

Jagan Mohan's trick works