topic Partial Total in QlikView

Partial Total

Fri, 26 Oct 2012 13:30:42 GMT

Hello All,

I have this calculation in expression:

if(ColumnNo()=0, aggr(sum(T_JOUR_OUVRABLE),EQUIPE,RES_RCAT_DESC,MOIS_NAME),sum(T_EMPLOYEE))

My Partial total does not work and it does not return any thing.

Any idea?

Thanks,

Nima

Re: Partial Total

Fri, 26 Oct 2012 13:51:05 GMT

I have 2 different calculation in rows and columns. so I say if it's the total of the columns do the first calcul otherwise do the 2nd calcul.

........

Re: Partial Total

Fri, 26 Oct 2012 13:53:58 GMT

need some sample,qvw or excel.

Re: Partial Total

Fri, 26 Oct 2012 13:55:25 GMT

I posted the excel ....

Thanks

Re: Partial Total

Fri, 26 Oct 2012 14:08:10 GMT

the more clearly u express the problem the easier it is to get the solution.

if u don't, then the one who is answering guesses what is needed.

Pls post what o/p u need from this excel file......at least i don't understand what is needed.

may be only take few entries from the excel as i/p & the o/p for that i/p cud b posted.

thanks for understanding

regards

Re: Partial Total

Fri, 26 Oct 2012 14:16:40 GMT

Thanks for replying.

I replace the excel file with a new version.Please look at the red cells and tell me why I don't have the total on the them? as you see I have the partial total on all the lines and columns except on the grand total for this column.

Thanks,

Nima

Re: Partial Total

Fri, 26 Oct 2012 15:19:51 GMT

I got it. Thanks for all your replies.

if(ColumnNo()=0,sum(aggr(max(T_JOUR_OUVRABLE),EQUIPE,MOIS_NAME)),sum(T_EMPLOYEE))

Re: Partial Total

CELAMBARASAN — Fri, 26 Oct 2012 15:42:44 GMT

Hi,

Aggr returns list or set of values its a best practice to use Aggr withing Sum function.