Qlik Community

Qlik Sense EA Powertools

Discussion board where members can learn more about Qlik Sense Powertools.

mohan_1105
Contributor 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

Tags (1)
5 Replies
hf-group
Contributor III

Re: How can we write a label expression?

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
Contributor III

Re: How can we write a label expression?

Hi Ralf,

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

hf-group
Contributor III

Re: How can we write a label expression?

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

mohan_1105
Contributor III

Re: How can we write a label expression?

Governed Metrics Service‌ I am using this service.

hf-group
Contributor III

Re: How can we write a label expression?

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.