topic Re: nested agrrgigation in Integration, Extension & APIs

nested agrrgigation

Anonymous — Wed, 24 Jan 2018 06:00:27 GMT

Hi Expert,

i wanted to do aggregation for the count value

if (count(sum(plan_cost)/sum(act_cost)>1 ,'success','fail') unable to do so in qlik sense..getting error nested aggregation

thanks

Re: nested agrrgigation

pradosh_thakur — Wed, 24 Jan 2018 06:06:47 GMT

something similar to this. not sure what you want to achieve though

if (count(aggr(sum(plan_cost)/sum(act_cost),your_dimension))>1 ,'success','fail')

Re: nested agrrgigation

Anonymous — Wed, 24 Jan 2018 06:36:25 GMT

can it be without dimension (your_dimension))

if (count(aggr(sum(plan_cost)/sum(act_cost),your_dimension))>1 ,'success','fail')

Re: nested agrrgigation

pradosh_thakur — Wed, 24 Jan 2018 12:13:56 GMT

where you want to display this ? i mean which object ? aggr() wont work without a dimension i guess. provide few more details ..

Re: nested agrrgigation

sunny_talwar — Wed, 24 Jan 2018 12:18:14 GMT

First of all, what are counting here? Success or Failures? Because you have both in your expression, you will get a overall count of both success and failures.

second, are you doing this in a chart or a text box object?