topic Re: Set and sum, nested aggregation not allowed in QlikView

Set and sum, nested aggregation not allowed

Mon, 19 Jan 2015 12:59:15 GMT

Hi I want to divide two formulas in one expression, seperately they work fine:

1. =Sum({<field1={'1'}>} field2)

2. =Sum({<field1={'1'}>} field2) - Sum({<field1={'1'}, field3={'-1'}>} field2)

But If try a version with (2.)/(1.) it does not work. If I try that i get 'nested aggregation not allowed' if I add serveral sum functions. Further more I tried to put them in two variables and then divide the variables, but then I get a wrong number. Do I need if and aggr instead?

Re: Set and sum, nested aggregation not allowed

maleksafa — Mon, 19 Jan 2015 13:05:58 GMT

try adding parentheses before each formula so that it will be

( Sum({<field1={'1'}>} field2) - Sum({<field1={'1'}, field3={'-1'}>} field2) )

(Sum({<field1={'1'}>} field2))

also what is the chart type that you are using?

Re: Set and sum, nested aggregation not allowed

alexandros17 — Mon, 19 Jan 2015 13:07:21 GMT

what is the mistake it returns when you do

(Sum({<field1={'1'}>} field2) - Sum({<field1={'1'}, field3={'-1'}>} field2))

(Sum({<field1={'1'}>} field2))

let me know

Re: Set and sum, nested aggregation not allowed

Mon, 19 Jan 2015 13:21:12 GMT

Thank you, so I just needed the parentheses at start, I was trying sum(sum(

BTW I seems like that I only need the extra parentheses in the long formula, because I substract two sum's and must capture that.

Re: Set and sum, nested aggregation not allowed

Mon, 19 Jan 2015 13:22:02 GMT

Well Malek was first but thank you.