Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
marcvw
Partner - Contributor III
Partner - Contributor III

remove '-' sign from table in Qlickview

Good Day All, 

In a table I have column that consist of positive and negative values. Is it possible to have the negative numbers diplayed as positive? See example below. 

Current future
-3418.82 3418.82
0.00 0.00
720.15 720.15
0.00 0.00
788.54 788.54
-1065.42 1065.42
16.02 16.02
1266.52 1266.52
4794.87 4794.87
-3097.91 3097.91
43.83 43.83
406.71 406.71
0.00 0.00
-437.15 437.15
0.00 0.00

 

Appreciate your support in here.

Labels (3)
1 Solution

Accepted Solutions
kfoudhaily
Partner - Creator III
Partner - Creator III

Hello,

Use the "fabs()" fonction

https://help.qlik.com/fr-FR/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Ge...

 

don't forget to mark as solved if it's ok for you.

 

regards,

QlikView Qlik Sense consultant

View solution in original post

1 Reply
kfoudhaily
Partner - Creator III
Partner - Creator III

Hello,

Use the "fabs()" fonction

https://help.qlik.com/fr-FR/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Ge...

 

don't forget to mark as solved if it's ok for you.

 

regards,

QlikView Qlik Sense consultant