Qlik Community

App Development

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

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Wouter_Denckens
Contributor
Contributor

convert text to number

Hi All,

I've been searching the forum for a specific problem … converting tekst to number.  My problem is the tekst has leading spaces and the number found has to be converted from American notation to European notation.

Ive tried several things, but this is what still results partly:

num#(price, '#.##0,00', '.', ',')

The problem I have is that all numbers up to 999.99 are converted corectly, any number above goes wrong and stays tekst.  Can anyone help me with this please?

Thanks in advance!

1 Solution

Accepted Solutions
NhanNguyen
Contributor III
Contributor III

Try num#(price, '#,###.#0', '.', ',')

View solution in original post

3 Replies
el_aprendiz111
Specialist
Specialist

Hi

Would you be able to share a sample?

NhanNguyen
Contributor III
Contributor III

Try num#(price, '#,###.#0', '.', ',')

Wouter_Denckens
Contributor
Contributor
Author

Thanks Nhan!  Why was my script wrong?  I assumed the second part of the num# function is the way it should return the data?