Expression dropping negative values

Fri, 09 Nov 2012 19:22:22 GMT

When I attempt to create a straight table the expression total is dropping any negative values from the table loaded. How do I include the negative values in my straight table? Example listed below.

Table before loaded into QlikView.

Field1 Field 2

A $1000

B $(500)

B $1000

C $(500)

C $1000

Total $2000

Table when creating a straigt table in Qlikview

Field1 Field 2

A $1000

B $1000

C $1000

Total $3000

Both total table should equal $2000. but after I load the data and use the Deminsion "Field1 and Expression "sum(Field2)" the negative values are not included in the Expression. How do I include the negative values in my straight table to get a total of $2000 instead of $3000?

Thanks

Brian

Re: Expression dropping negative values

MayilVahanan — Fri, 09 Nov 2012 19:46:45 GMT

I think (500) is not considered as negative value here..

LOad *,If(SubStringCount(Field2,'('),PurgeChar(Field2,'()')*-1,Field2) as Field3 Inline

[

Field1,Field2

A,1000

B,(500)

B,1000

C,(500)

C,1000

];

Then use Field1 as dimension, sum(Field3) as expression..

PFA

Hope it helps

topic Expression dropping negative values in QlikView

Expression dropping negative values

Re: Expression dropping negative values