Qlikview Formatting Question

[flexbox]

Hi guys,

I've a .qvd which provides me columns with data and positive and negative numbers. The column with numbers is recognized as a text-string. My problem is that the negative numbers have the format e.g. 720,01- .

Is it possible to change the negative numbers in a format like this -> -720,01  ??? I've tried several things (num#() ...) with no result.

Thanks in advance.

[Vegar]

if it is recognised as a  number then it is unnecessary to reinterpret it as a num. You need to format it.

Try using num() instead  of num#().

Take a look at @Jennell_McIntire latest blog post Date# Function vs. Date Function ( https://community.qlik.com/t5/Qlik-Design-Blog/Date-Function-vs-Date-Function/ba-p/1837175 ). The same principles applies to Num# vs Num functions. 

[flexbox]

Thank's for the fast reply. 

Unfortunately it's not recognized as a number 😞

[marcus_sommer · Accepted solution]

This should work: num(num#('720,01-', '#.#;#.#-', ',', '.'))

- Marcus

[flexbox]

Big thx! It worked!!