Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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.

Community Browser