Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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