topic Re: Wrong partial sums in QlikView

Wrong partial sums

Wed, 28 Sep 2016 09:42:23 GMT

Hello

I created a qvw and on the expressions I have multiple IF statements in order to calculate the data as shown on the attached picture.

The problem is that when I ask for partial Sums on pivot table or totals on straight table, the totals are wrong.

What I am loosing?

expression eg. :

IF((PLAN_START_YEAR_MONTH-YEAR_MONTH)=0,sum(PLResult_EndFishNo),

IF((Sum(PLResult_EndFishNo)=0),sum(COSTMAIN_EndFishNo),(Sum(PLResult_EndFishNo)))).

The first IF statement is applied on the 8th month .

Thu, 29 Sep 2016 11:50:10 GMT

This is the correct syntax.

SUM(AGGR((IF((PLAN_START_YEAR_MONTH-YEAR_MONTH)<=0,SUM(PLResult_EndFishNo),

IF((PLAN_START_YEAR_MONTH-YEAR_MONTH)>0,SUM(COSTMAIN_EndFishNo)))),THEYEAR,THEMONTH))

Gysbert_Wassenaar — Thu, 29 Sep 2016 15:54:18 GMT

Try this: sum(aggr( ...original expression here ... , YEAR, MONTH))

nagarjuna_kotha — Thu, 29 Sep 2016 15:56:05 GMT

in stright table ,

Goto expression table and select Sum o Row,

I guess u ll get solution

If not try to share sample data to get better solution

-Nagarjun

sunny_talwar — Thu, 29 Sep 2016 16:00:10 GMT

Try wraping it with Sum(Aggr(...., YEAR, MONTH))

Sum(Aggr(

IF((PLAN_START_YEAR_MONTH-YEAR_MONTH)=0,sum(PLResult_EndFishNo),

IF((Sum(PLResult_EndFishNo)=0),sum(COSTMAIN_EndFishNo),(Sum(PLResult_EndFishNo))))

, YEAR, MONTH))

Tue, 04 Oct 2016 10:19:20 GMT

I tried this from the beginning.It is wrong due to different fields that must be aggregated.