Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total Not Working in Nested If's

Hi, I have this expression on my chart

ALT(if([Sub Channel] = 'Test Account',IF(((sum({$<[Notification Description] = {'Transaction Funded'}>}Commision))) > 2, 2))

    , (sum({$<[Notification Description] = {'Transaction Funded'}>}Commision)))

It works, but the also sets the total to the first condition. I tried AGGR

ALT(aggr(if([Sub Channel] = 'Test Account',IF(((sum({$<[Notification Description] = {'Transaction Funded'}>}Commision))) > 2, 2)),EXTERNAL_ID)    , (sum({$<[Notification Description] = {'Transaction Funded'}>}Commision)))

but this still doesnt work, any idea how to get my total to sum up correctly.

0 Replies