Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

rupesh632
Contributor

nested agrrgigation

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

4 Replies
pradosh_thakur
Honored Contributor II

Re: nested agrrgigation


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

Learning never stops.
rupesh632
Contributor

Re: nested agrrgigation

can it be without dimension (your_dimension))


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

pradosh_thakur
Honored Contributor II

Re: nested agrrgigation

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

Learning never stops.

Re: nested agrrgigation

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?

Community Browser