topic Can we use nested aggr in QlikView

Can we use nested aggr

Mon, 23 Jun 2014 12:31:39 GMT

I have written an aggr(sum(distinct salary),SKILL_NAME,EMP_ID,YEAR,MONTH) ). Now I want to do

an aggregation of the sum we got in the above aggregation, based on SKILL_NAME AND EMP_ID. To make it clear, lets assume the sum we got in first aggr as SUM1.

So I want aggr(sum(sum1),SKILL_NAME,EMP_ID). How can we do this.

Thanks in advance.

Regards

Santhosh.

Re: Can we use nested aggr

juleshartley — Mon, 23 Jun 2014 12:41:15 GMT

It seems that the main reason that you are doing this is so that you have a distinct monthly sales figure by Emp_ID and skill... so perhaps worth creating a monthly sales table in your data model?

Re: Can we use nested aggr

tresB — Mon, 23 Jun 2014 12:41:40 GMT

Yes you can.

Aggr(Sum(aggr(sum(distinct salary),SKILL_NAME,EMP_ID,YEAR,MONTH) ) ),SKILL_NAME,EMP_ID) - I guess, it's a valid one. Have you tried? Isn't it working?