Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Usama
Creator
Creator

Currency Conversion

Hi,

I have source value as following:

Usama_0-1597838833859.png

Usama_1-1597839142507.png

When i am trying to Sum(value).  Then getting 0. I know its string for that i have tried Num() & Num#() as well but both not working. When i use Num(Value), all the values in filter pane disappears.  

From Nothing - To Something - To Everything
Labels (3)
3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

this script should help you 

load if(index(value,'M')>0,PurgeChar(value,'M')*1000000,value) as value;
load PurgeChar(value,'€') as value;
Load * Inline [
value 
€0
€1.1M
€1.2M
€1.3M
€1.4M
€1.1M
€1.2M
€1.1M
];
rrsrini2907
Creator
Creator

How about this option.

Keepchar(value, '0123456789.')

Little contradicted with the number format. Money is Euro where Decimal places is separate by "," and thousand is separated by "."

Check if above function provide you desired result.

Usama
Creator
Creator
Author

hi,
Its not working. Can you please make me correct if its wrong:

Usama_0-1597927727519.png


Thanks

From Nothing - To Something - To Everything