Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sum Positive and Negative Numbers qlikview Regardless of Sign


Hi All,

Is it possible to get sum of negative and positive Numbers Regardsless of sign.I am using this expression (DOCNUM)-count(DMSDOCNUM) but it is not solving my problem. i Should be getting around 35000 records but beacuse of negative and positie sign i am only getting 2700 records.

Can anyone please help me with this.  Attaching my case scneraio here.

Regards,

vikas

3 Replies
Employee
Employee

Re: Sum Positive and Negative Numbers qlikview Regardless of Sign

use

=fabs()

Not applicable

Re: Sum Positive and Negative Numbers qlikview Regardless of Sign

Hey Alejandro,

I tried that but its not working! Do you have any other sugession?

Regards,

Vikas

MVP
MVP

Re: Sum Positive and Negative Numbers qlikview Regardless of Sign

Hi Vikas,

Try like this

=Fabs(DOCNUM)+ count(DMSDOCNUM)

If it is not working then check with if like this

if(Number < 0, Number * -1, Number)

Hope this helps you.

Regards,

Jagan.

Community Browser