topic Re: May i know how to use Qlik Sense Sept 2017 label expression ? in App Development

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

paulyeo11 — Mon, 25 Sep 2017 08:44:21 GMT

Hi All

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

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

shraddha_g — Mon, 25 Sep 2017 09:09:17 GMT

it is same as for Title in Chart.

then you can use

getfieldselections(bRAND)

else

try maxstring(bRAND)

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

paulyeo11 — Mon, 25 Sep 2017 09:23:15 GMT

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

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

shraddha_g — Mon, 25 Sep 2017 10:05:51 GMT

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.'?

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

paulyeo11 — Mon, 25 Sep 2017 11:38:15 GMT

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>

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

shraddha_g — Tue, 26 Sep 2017 06:09:27 GMT

Then in Fx Editor put 'Sales Amount'.

That's it.

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

paulyeo11 — Tue, 26 Sep 2017 06:23:54 GMT

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>

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

shraddha_g — Tue, 26 Sep 2017 07:31:43 GMT

Max(Fieldname)

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

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

paulyeo11 — Tue, 26 Sep 2017 08:15:35 GMT

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.

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

shraddha_g — Tue, 26 Sep 2017 08:42:52 GMT

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

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

paulyeo11 — Tue, 26 Sep 2017 08:59:19 GMT

Hi Shraddha

Thank you for your help. I manage to figure out . By using the Sept 2017 Ver , i Crete a master items “sum(sales)” and at label I write :-

=if( SOURCE=‘TDSS’,’SG’,

If(SOURCE = .....

It work fine now.

Thank you for your help.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

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

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

shraddha_g — Tue, 26 Sep 2017 09:01:42 GMT

Great!