Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER 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?

1 Solution

Accepted Solutions
BrianDH
Creator II
Creator II

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

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