Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
razvan_brais
Creator III
Creator III

Modify display value when sum<0

Hey guys. Me again. How can I modify the display of a value that is lower then 0;

I want that if the result is <0 to display it like this (value).

So if value is -150 to display (150)

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Where you want to show this. I mean which object. If text object might be my solution is not work left all will work

Tri properties and them number tab choose

#.000; (#.000)

This format will give all positive number.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

6 Replies
Chanty4u
Champion III
Champion III

try

use Fabs function

Fabs(urexpression)

EX:

If(fabs(sum(sales)=0,Value)

sushil353
Master II
Master II

Hi,

you can set the format like :

=num(sum(test),'#,##0.0;(#,##0.0)')

HTH

Sushil

razvan_brais
Creator III
Creator III

Do I have to write it in the text format of the expression , or it`s in the expression itself?

balrajahlawat
Champion
Champion

Just use Fabs(Fieldname) as script, it will treat all -ve values as +ve values

Anil_Babu_Samineni

Where you want to show this. I mean which object. If text object might be my solution is not work left all will work

Tri properties and them number tab choose

#.000; (#.000)

This format will give all positive number.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

razvan_brais
Creator III
Creator III

Thank Anil , that worked.