topic Re: Presenting Negetive Values in QlikView

Presenting Negetive Values

roee1983 — Sun, 29 Sep 2013 09:30:15 GMT

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

Re: Presenting Negetive Values

jagan — Sun, 29 Sep 2013 15:45:30 GMT

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.

Re: Presenting Negetive Values

Anonymous — Sun, 29 Sep 2013 21:27:42 GMT

Roee

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

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

See attached qvw.

Best Regards, Bill

Re: Presenting Negetive Values

Clever_Anjos — Sun, 29 Sep 2013 21:49:26 GMT

sum(if(yourfield>0,yourfield))

Re: Presenting Negetive Values

tresB — Mon, 30 Sep 2013 04:44:21 GMT

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.

Re: Presenting Negetive Values

MayilVahanan — Mon, 30 Sep 2013 04:44:46 GMT

Try like this

Load * from tablename where values > 0;

Re: Presenting Negetive Values

vikasmahajan — Mon, 30 Sep 2013 05:05:02 GMT

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

Vikas

Re: Presenting Negetive Values

Mon, 30 Sep 2013 05:16:30 GMT

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

Re: Presenting Negetive Values

qlikpahadi07 — Mon, 30 Sep 2013 05:50:14 GMT

Hi Roee,

you can simply remove with if condition

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

Re: Presenting Negetive Values

nizamsha — Mon, 30 Sep 2013 06:09:04 GMT

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

Re: Presenting Negetive Values

Mon, 30 Sep 2013 06:33:06 GMT

by using filter u prevent negetive values

let suppose customer is ur dimension and sum(sales) is expression

in ur dimension tab use below expression

=if(Sales > 0, Company,Null())

then u avoid the negetive values,

Re: Presenting Negetive Values

jonathandienst — Mon, 30 Sep 2013 07:49:16 GMT

Use Rangemax(0, Value) for your expression and make sure that Suppress Zero Values is checked. (Replace Value with the correct field name).

Regards

Jonathan

Re: Presenting Negetive Values

techvarun — Mon, 30 Sep 2013 08:11:38 GMT

Hi,

On which level you need to restrict the negative values?

on scrip level or in expression level?

Regards

Re: Presenting Negetive Values

techvarun — Mon, 30 Sep 2013 08:15:26 GMT

by the below script you can restrict it on the script level

Directory;

LOAD Filed1,

Field2

FROM

[..\Table1.xls]

(biff, no labels, table is [Sheet1$])

WHERE(Field2 > '0');

Re: Presenting Negetive Values

rbecher — Mon, 30 Sep 2013 08:22:31 GMT

Hi,

do you mean in the load script or in a chart?

- Ralf

Re: Presenting Negetive Values

jvitantonio — Mon, 30 Sep 2013 08:24:05 GMT

Hello, if you want to do this in the script, it would be like this:

TableA:

LOAD

Description, Value

From ...

where Value > 0;

If you'd like to do it directly in your pivot, in your expression write:

If(Value >0, Sum(Value), null())

I hope this helps.

Re: Presenting Negetive Values

Mon, 30 Sep 2013 09:01:08 GMT

In the expressions tab, add an if statement as follows:

=if(columnname<0,0,columnname)

In Presentations tab, select the specific column and at the bottom enable check box "Suppress Zero-Values"

Re: Presenting Negetive Values

vivek_niti — Mon, 30 Sep 2013 09:10:22 GMT

Hi,

Do you want this to be done in front-end or back-end???

If u have to remove the data from the backend then just add a where condition in the script...

WHERE VALUE <=0;

or if the condition has to be added in front-end then just add an IF condition to the expression.

SUM(If((VALUE)>=0,VALUE,0))

Regards,

Vivek

Re: Presenting Negetive Values

mdmukramali — Mon, 30 Sep 2013 09:15:51 GMT

Dear Roee,

use the below expression.

=if(sum(Price)>0,sum(Price))

i hope it will help u.

kindly find the attachment.

Thanks,

Mukram.

Re: Presenting Negetive Values

Mon, 30 Sep 2013 09:19:57 GMT

Hi Roee,

Assuming that this is your data:

Table A:

colA, colB

pro1, 15

pro2, 30,

pro3, -40

You can use this in expression :

If([colB]>0,[colB])
This will hide the negative records.

Hope this helps!