Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can i Convert a row containing the float value (6.60) into the -6.60

I have a "*.csv" file with comma separated, containing a row of data type 'FLOAT' with value '(6.60)' , i have to convert this row into '-6.60'

How can i convert this?

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi 

You Can use Mathematical.NEG function it will  Returns the arithmetic additive inverse of the value of the argument.

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Hi 

You Can use Mathematical.NEG function it will  Returns the arithmetic additive inverse of the value of the argument.

manodwhb
Champion II
Champion II

@meetmahajan,convert float to sting and add "-" before the float to sting expression.

Anonymous
Not applicable
Author

Thanks both the solutions working perfectly.

 

Conversion Syntax :  Mathematical.NEG(Double.parseDouble(Variable.replaceAll("\\(", "").replaceAll("\\)","").trim()))