Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
can it be without dimension (your_dimension))
if (count(aggr(sum(plan_cost)/sum(act_cost),your_dimension))>1 ,'success','fail')
where you want to display this ? i mean which object ? aggr() wont work without a dimension i guess. provide few more details ..
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?