Qlik Community

Qlik Sense Integration, Extensions, & APIs

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

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Master II
Master 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.
Highlighted
Creator
Creator

Re: nested agrrgigation

can it be without dimension (your_dimension))


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

Highlighted
Master II
Master 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.
Highlighted

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?