topic Re: Negative values in field in QlikView

Negative values in field

Mon, 29 Dec 2014 05:49:58 GMT

Hi all,

i got both negative and positive values in field how to distinguish them like positive,negative, Sum(positive and negative) .

give me some examples please.

thanks,

amit_saini — Mon, 29 Dec 2014 05:53:52 GMT

Janaki,

Check this

Thanks,
AS

Mon, 29 Dec 2014 06:03:42 GMT

can you provide script please ,i haven't got lic here at the moment.

amit_saini — Mon, 29 Dec 2014 06:10:05 GMT

Suppose this is your script:

load * inline [

A, B

a,-1

b,-2

c,-1

d,-3

e,-4

];

Now create a bar charts with A as dimmenison and =fabs(sum(B)) as expression for negative values.

So in this way you can show both -ve and +ve values in two different bars.

You can create one more filed as "C" in script with positive numbers and check as Sum(c)

Thanks,
AS

jyothish8807 — Mon, 29 Dec 2014 06:12:08 GMT

Hi Janaki,

Simply add an expression sum(Your field). You can use a bar chart.

PFA

Regards

Mon, 29 Dec 2014 06:24:15 GMT

THANK YOU AMITH

amit_saini — Mon, 29 Dec 2014 06:28:15 GMT

Cheers !

and its Amit without ->"H"

Thanks,
AS

Anonymous — Mon, 29 Dec 2014 06:32:51 GMT

Hi Use the

fabs() function in the expression

=Fabs(Sum(Sales))