Aggregating values from 2 cells

Fri, 08 Jan 2016 10:04:06 GMT

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?

Re: Aggregating values from 2 cells

Gysbert_Wassenaar — Fri, 08 Jan 2016 17:32:11 GMT

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')

topic Aggregating values from 2 cells in QlikView

Aggregating values from 2 cells

Re: Aggregating values from 2 cells