Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregating values from 2 cells

Hi,

This is what I've got atm which returns me a value, but I would also like to add the sum of another value: sub_exec_broker={''NEONT'}. Aggregating these two, in a total. Anyonwe that can help?

Capture1.PNG

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

If there are no records where both exec_broker and sub_exec_broker have the value NEONT then you can use this:

Num(Sum({<exec_broker={'NEONT'}>+<sub_exec_broker={'NEONT'}>}TurnoverSEK),'#.##0')

Otherwise you may want to use this instead:


Num(RangeSum(Sum({<exec_broker={'NEONT'}>}TurnoverSEK),Sum({<sub_exec_broker={'NEONT'}>}TurnoverSEK)),'#.##0')


talk is cheap, supply exceeds demand