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

[paulyeo11]

Hi All

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

[shraddha_g]

it is same as for Title in Chart.

then you can use

getfieldselections(bRAND)

else

try maxstring(bRAND)

[paulyeo11]

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]

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]

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 · Accepted solution]

Then in Fx Editor put 'Sales Amount'.

That's it.

[paulyeo11]

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]

Max(Fieldname)

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

[paulyeo11]

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]

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