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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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