Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
paulyeo11
Valued Contributor III

How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

Hi All

How to make 158,488.24 display Euro 158,488.24 ?

Mr Ram help me with the below expression from above post , it will display Currency word on the Amount . For example 158 will display as SGD 158 if Curr = SGD :-

Curr & '  '  & Num(Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}InvoiceOrg),'###,##0.00')

May i know does it able to change it to international currency sign ?

Paul

1 Solution

Accepted Solutions
Highlighted

Re: How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

Hi Paul,

You have used two USD's in pick match function. You can get the result by removing one USD. Have a look at the attachment.

Capture.PNG

View solution in original post

9 Replies
Highlighted
Not applicable

Re: How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

Try this.

Highlighted

Re: How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

Hi Paul,

Try this expression.

Pick(Match(Curr,'EUR','YEN','USD','NT'),'€','¥','$','NT$') & '  '  & Num(Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}InvoiceOrg),'###,##0.00')

Highlighted
paulyeo11
Valued Contributor III

Re: How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

Hi Tamil

Thank you very much for your expression  , it work fine , except that for USD currency , it does not display US$ . the rest work fine. Can you share with me why ? As i like the way you write the expression not using IF.

Paul

Highlighted
paulyeo11
Valued Contributor III

Re: How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

Hi Ram

Look like your expression is better. it work fine , except that it create many Other currency in chinese charater. I manage to find out it is due to my data model not well organise . Because when i using reduce data load by select only SOURCE = TDSS ,  all the chinese charater missing.

Any idea why you using chinese charater for replace other ?

Paul

Highlighted

Re: How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

To get US$ just change the pick/match command to change '$' to 'US$'

old expression

Pick(Match(Curr,'EUR','YEN','USD','NT'),'€','¥','$','NT$') & ...


change to

Pick(Match(Curr,'EUR','YEN','USD','NT'), '€','¥','US$','NT$') & ...

Highlighted
paulyeo11
Valued Contributor III

Re: How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

Hi Colin

I aware of the changes , when i try it still don't display. when i try to replace EUR with SGD it can display Euro currency sign. But when i replace SGD to EUR again it not work. Have  you try ?

Paul

Highlighted

Re: How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

Hi Paul,

You have used two USD's in pick match function. You can get the result by removing one USD. Have a look at the attachment.

Capture.PNG

View solution in original post

Highlighted
paulyeo11
Valued Contributor III

Re: How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

Hi Tamil

Below expression not ok :-

Pick(Match(Curr,'EUR','YEN','USD','NT','SGD',),'€','¥','$','NT$','S$') & '  '  & Num(Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}InvoiceOrg),'###,##0.00')

Below expression from your  working fine :-

Pick(Match(Curr,'EUR','YEN','USD','NT','SGD',),'€','¥','US$','NT$','S$') & '  '  & Num(Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}InvoiceOrg),'###,##0.00')

I notice that , the different is only US currency sign $ and US$

So i copy the working expression , i change from US$ to $ :-

Pick(Match(Curr,'EUR','YEN','USD','NT','SGD',),'€','¥','$','NT$','S$') & '  '  & Num(Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}InvoiceOrg),'###,##0.00')

Above expression cannot work . when i change back $ to US$ , it work fine .

So the issue is i need to put some letter infront of the $. like US$

it take me a while to figure out , thank you very much.

Paul

Highlighted

Re: How to convert EUR instead of EUR 158 into international Currency Sign ? ( C with 2 hor line )

Great. Have a nice day Paul.