nested agrrgigation

[Anonymous]

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

[pradosh_thakur]

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

[Anonymous]

can it be without dimension (your_dimension))

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

[pradosh_thakur]

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

[sunny_talwar]

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?