Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register 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
Partner

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