Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
flexbox
Contributor II
Contributor II

Qlikview Formatting Question

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.

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

4 Replies
Vegar
MVP
MVP

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. 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
flexbox
Contributor II
Contributor II
Author

Thank's for the fast reply. 

Unfortunately it's not recognized as a number 😞

marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

flexbox
Contributor II
Contributor II
Author

Big thx! It worked!!