Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

May i know how to use Qlik Sense Sept 2017 label expression ?

Hi All

Hope some one can share with me how to use this ?

label expression.png

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: May i know how to use Qlik Sense Sept 2017 label expression ?

Then in Fx Editor put 'Sales Amount'.

That's it.

11 Replies
shraddha_g
Honored Contributor III

Re: May i know how to use Qlik Sense Sept 2017 label expression ?

it is same as for Title in Chart.

then you can use

getfieldselections(bRAND)

else

try maxstring(bRAND)

paulyeo11
Valued Contributor II

Re: May i know how to use Qlik Sense Sept 2017 label expression ?

Hi Shraddha

Yes , for the Core Brand Dimension it work fine.

Now I have measure = sum(sales) /rate

In the label I need it display Sales Amount S$K.

Can you advise me the expression , how should I enter ?

Paul Yeo

shraddha_g
Honored Contributor III

Re: May i know how to use Qlik Sense Sept 2017 label expression ?

Use expression over there....

It will display total value of your expression.

Do you want to show dynamic label or static label as 'Sales Amount S$K.'?

paulyeo11
Valued Contributor II

Re: May i know how to use Qlik Sense Sept 2017 label expression ?

Hi Shraddha

I don’t need dynamic now . Just want it display “ Sales Amount “.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

shraddha_g
Honored Contributor III

Re: May i know how to use Qlik Sense Sept 2017 label expression ?

Then in Fx Editor put 'Sales Amount'.

That's it.

paulyeo11
Valued Contributor II

Re: May i know how to use Qlik Sense Sept 2017 label expression ?

Hi shraddha

Thank you very much for your reply.

So you are refer to put the Measure for sum(sales) , label for fx = sales Amount.

In case I need it be dynamic . Can you share with me how to do it .

Take for example

Brand = Beckhoff , display Euro

Brand = Hakko , display Japan

Brand = Project , display Singapore

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

shraddha_g
Honored Contributor III

Re: May i know how to use Qlik Sense Sept 2017 label expression ?

Max(Fieldname)

At the Fieldname put a name of field containing values as Euro,Japan,Singapore

paulyeo11
Valued Contributor II

Re: May i know how to use Qlik Sense Sept 2017 label expression ?

Hi Shraddha,

My chart 1 how to make it display different country when user click on different SOURCE ?

SOURCE = TDSS , SINGAPORE CURRENCY

SOURCE=TDSID, INDONESIA CURRENCY

COURCE=TDSKL,MALAYSIA CURRENCY.

Now it display Sales Amount.

Paul Yeo.

shraddha_g
Honored Contributor III

Re: May i know how to use Qlik Sense Sept 2017 label expression ?

On selection of Source as TDSS or TDSID or TDSKL I couldn't find unique country value