Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
mohan_1105
Partner - Creator III
Partner - Creator III

How can we write a label expression?

Hi,

I suppose wanted to write a label expression for the expression I loaded using GMS service. I tried using the demo expression, I manually enter the label expression in the master library and when I do a small correction in the excel sheet and reload the service. I see the manually entered label expression disappeared.

Is there is any way to write a label expression on the excel sheet itself?

Regards,

Mohan

Labels (2)
5 Replies
Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

You can use Variables for that:

Set Variables using excel file

Or if you want more than one language you can work with id´s in a excel file

ID               German               Englisc

1                 Haus                   house

and use

=only({<No = {1}>} German)

=only({<No = {1}>} English)

you can also use a variable for that

=only({<No = {1}>} $(v_language))

and set the variable in an extension by buttons for example

mohan_1105
Partner - Creator III
Partner - Creator III
Author

Hi Ralf,

Can explain in detail about how label expression(Set variable) can be written when I'm using GMS demo excel?

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

Can you first explain me what you mean with GMS demo excel?

mohan_1105
Partner - Creator III
Partner - Creator III
Author

Governed Metrics Service‌ I am using this service.

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

Unfortunately I have no experience with GMS. So I understand your question wrong. My answer works when you read a excel file direct in your load script.