Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BrianDH
Creator II
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)
1 Solution

Accepted Solutions
BrianDH
Creator II
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)

View solution in original post

1 Reply
BrianDH
Creator II
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)