Presenting Negetive Values

[roee1983]

Hi all,

How can I ignore negative values ?

I have a table with next values

Table A:

pro1,15

pro2,30

pro3,-40

How can I prevent showing the negative record?

thanks

Roee

[jagan]

Hi,

If you want to restrict in script then use the below script

LOAD

*

FROM Table

WHERE Value >= 0;

If you want to do the same in expression then use the below expression

=Sum({<Value={'>0'}>} Value)

Regards,

Jagan.

[Anonymous]

Roee

Try using a Chart of Type Straight Table and a calculated dimension :

=if ( Value > 0 , Pro , null() )

See attached qvw.

Best Regards,     Bill

[Clever_Anjos]

sum(if(yourfield>0,yourfield))

[tresesco]

If you want the negative values to be excluded during load, try like :

Load Field1,

          Field2

From <> Where Field2>=0;

If you want to restrict only in the fron-end (table), try like:

If(Field2>=0, Field2)    , this you could try in list box or in calculated dimension or even in an expression.

[MayilVahanan]

Hi

Try like this

Load * from tablename where values > 0;

[vikasmahajan]

You can select option Suppress When Values is Null Option in pivot table.

Vikas

[#8]

You want to ignore negative values or you want to show negative values are in postive.

[qlikpahadi07]

Hi Roee,

you can simply remove with if condition

if Sum(<column A >)<0, Sum(<column A >)

[nizamsha]

use fabs in the column in your script for eg : fabs(amount)