Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
maverjannet
Valued Contributor

Re: greater than and less than

try  this.

if(DIFFERENCE<>0,count(DIFFERENCE))

or

if(DIFFERENCE<>,fabs(Sum(DIFFERENCE)))

mov
Esteemed Contributor III

Re: greater than and less than

O well:

='Total: ' & sum(if(DIFFERENCE>0,DIFFERENCE)) - sum(if(DIFFERENCE<0,DIFFERENCE))

mazman65
New Contributor III

Re: greater than and less than

Thank you all for the help.

This expression worked-

='Total Bank Lock Box Differences:  ' & count(if(DIFFERENCE<>0,DIFFERENCE))

Dan

Community Browser