topic Re: Sum value based on + and - values in QlikView

Sum value based on + and - values

Thu, 13 Mar 2014 11:43:44 GMT

Hi All,

can anyone help me out in building logic/ writing exoression.

I want to sum the value from one field having positive and negative values.

the data in field is like this

Fieldname

500

550

-44

-456

I want to classify positive and negative values into two expressions.

can i use set analysis..like operator? what couls best way to represent?

Thank you

Regards,

Prajna

christophebrault — Thu, 13 Mar 2014 11:46:46 GMT

Hi,

you can do something like this :

Sum({$<Fieldname={">0"}>}Fieldname) for positives

Sum({$<Fieldname={"<0"}>}Fieldname) for negatives

Thu, 13 Mar 2014 11:52:27 GMT

Thank you

Regards,

Prajna

er_mohit — Thu, 13 Mar 2014 11:54:33 GMT

See the attached file