topic Re: Expression in QlikView

Expression

Sat, 23 Jan 2016 18:59:06 GMT

Hello,

I am having difficulty getting my expression to show the correct result.

=Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL DR])

Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL CR])

Sum([Collections Recovery Chargeback Collection Recovery])

Sum([Risk Credit Rejects Total Sales])

Result for the first part of that expression is $2,127,826.04.

Result for the second part of that expression is $10,880,952,862.78.

The end result should be 0.019%.

I have verified through calculation. Where I am trying to put this expression is in a Gauge Chart configuration. I am not coming up with a result of that 0.019%.

Any help would be appreciated.

Thanks

Manny

Re: Expression

sunny_talwar — Sat, 23 Jan 2016 19:40:03 GMT

What are you stating as the first and second parts here??? May be you need to add parenthesis around the numerator:

=(Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL DR])

Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL CR])

Sum([Collections Recovery Chargeback Collection Recovery]))

Sum([Risk Credit Rejects Total Sales])

Because in your current state only this -> Sum([Collections Recovery Chargeback Collection Recovery]) is getting divided by the denominator.

HTH

Best,

Sunny

Re: Expression

Sat, 23 Jan 2016 19:41:46 GMT

Hi Sunny,

By first part I mean:

=Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL DR])

Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL CR])

Sum([Collections Recovery Chargeback Collection Recovery])

Second part is:

Sum([Risk Credit Rejects Total Sales])

Re: Expression

sunny_talwar — Sat, 23 Jan 2016 20:11:51 GMT

Did you try putting the parenthesis around the numerator as I suggested?

=(Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL DR])

Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL CR])

Sum([Collections Recovery Chargeback Collection Recovery]))

Sum([Risk Credit Rejects Total Sales])