Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I trim an amount in a textbox?

Hello to all,

i have a new question to format a textbox.

The textbox looks "12,34564345 €",

what can I do, that the textbox should like looks "12,34 €'

Can anybody help me.

Thank you.

1 Solution

Accepted Solutions
Not applicable
Author

If you have some expression in a textbox, you can do this:

num(sum(Something), '#0,00')

View solution in original post

2 Replies
tresesco
MVP
MVP

 

=

Left('12,34564345 €',5)&Right('12,34564345 €',2)

Not applicable
Author

If you have some expression in a textbox, you can do this:

num(sum(Something), '#0,00')