topic Re: Euro sign in text object in QlikView

Euro sign in text object

Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

the current sales for Diamond Point.nl in a text object looks like this:

i am using the current expression to show 5710:

=round(sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity))

My wish is to show €5710 is this text object. which expression should i use ?

Thanks.

Greets,

Rega

Re: Euro sign in text object

Anonymous — Thu, 07 Apr 2016 13:19:38 GMT

You probably need to use the Chr() function and the decimal ascii for € of 8364, so maybe something like :

=chr(8364) & round(sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity))

Re: Euro sign in text object

sunny_talwar — Thu, 07 Apr 2016 13:19:44 GMT

May be this:

Num(Round(Sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity)), '€#,###.0')

Re: Euro sign in text object

engishfaque — Thu, 07 Apr 2016 13:57:51 GMT

Dear Rega,

Use listed below expressions according to your requirement.

Expression1:

=Num(round(sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity)), '€#,##0.00')

Expression2:

=Num(round(sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity)), '€#,##0')

Kind regards,

Ishfaque Ahmed

Re: Euro sign in text object

swuehl — Thu, 07 Apr 2016 14:02:51 GMT

If you are fine with the default money format as defined in your script:

=Money( round(sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity) )

Re: Euro sign in text object

engishfaque — Thu, 07 Apr 2016 14:11:35 GMT

Dear Rega,

If you are going to use Money function such as suggested by @Stefan then you need to make change on your edit script Main tab and place this money format:

SET MoneyFormat='€#,##0.00;(€#,##0.00)';

Kind regards,

Ishfaque Ahmed

Re: Euro sign in text object

Thu, 07 Apr 2016 14:19:37 GMT

Thanks All !