# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for
Search instead for
Did you mean:  Creator II

## Comparing Numbers Question

Team

I am trying to show only records where my CAP amount is not equal to my Spend Amount however I am getting a record where the amounts are the same, as far as I can tell (See Image).

Aggr(if(Sum(B_BH_AMOUNT_CAP) <> SUM(B_BH_AMOUNT_ACT + B_BH_AMOUNT_PAY + B_BH_AMOUNT_GLA +B_BH_AMOUNT_GLL +B_BH_AMOUNT_GLQ +B_BH_AMOUNT_GLR +B_BH_AMOUNT_GLE +B_BH_AMOUNT_OTHER)
,MasterKey),MasterKey)

Suggestions?

Labels (4)

• ### Qlik Sense

1 Solution

Accepted Solutions  Creator II
Author

Resolved Trim()

Aggr(if(Sum(B_BH_AMOUNT_CAP) <> Trim(SUM(B_BH_AMOUNT_ACT + B_BH_AMOUNT_PAY + B_BH_AMOUNT_GLA +B_BH_AMOUNT_GLL +B_BH_AMOUNT_GLQ +B_BH_AMOUNT_GLR +B_BH_AMOUNT_GLE +B_BH_AMOUNT_OTHER))
,MasterKey),MasterKey)

1 Reply  Creator II
Author

Resolved Trim()

Aggr(if(Sum(B_BH_AMOUNT_CAP) <> Trim(SUM(B_BH_AMOUNT_ACT + B_BH_AMOUNT_PAY + B_BH_AMOUNT_GLA +B_BH_AMOUNT_GLL +B_BH_AMOUNT_GLQ +B_BH_AMOUNT_GLR +B_BH_AMOUNT_GLE +B_BH_AMOUNT_OTHER))
,MasterKey),MasterKey) 