Expression Total Coming Wrong Due To Using Nested Aggregation

Fri, 24 Feb 2012 22:42:32 GMT

Dear All,

I am working on a table in this total of expression of column is coming wrong. I try so many thing but faialed.

I am using nested sum in the Expression of this column, I trying to convert this expression in aggr but I failed my this is the reson of this.

Expression is :

( sum( { $ <trnType={'Sales'}, [Financial Year]= > } OfferAvgDays ) + sum( { $ <trnType={'ODS'}, [Financial Year]= > } invGrTotal ) )

if(trnType='Sales' and

date(if( trnType='Sales' and OfferAvgDays<>0,(docDate+round(avg( { $ <trnType={'Sales'}, [Financial Year]=, OfferAvgDays={0}, invGrTotal={'<>0'} > } recdInDays )))),'DD/MM/YYYY') >= vInputDate and

date(if( trnType='Sales' and OfferAvgDays<>0,(docDate+round(avg( { $ <trnType={'Sales'}, [Financial Year]=, OfferAvgDays={0}, invGrTotal={'<>0'} > } recdInDays )))),'DD/MM/YYYY')<= date(fyDate2,'DD/MM/YYYY'),OfferAvgDays,0

)

I was trying to convert expression which part is in bold in aggr but I was fail

So please help to solve thies 2 problem related to each other in my opinion.

I am attaching my sample QV here.

Thanks & Regards.

- anil

Re: Expression Total Coming Wrong Due To Using Nested Aggregation

Sun, 26 Feb 2012 13:31:17 GMT

Just change the total mode to sum of rows

Expression Total Coming Wrong Due To Using Nested Aggregation

jagan — Mon, 27 Feb 2012 06:21:46 GMT

Hi,

If you are using chart as Straight table then you can set Total Mode as Sum of Rows. This sums up the values in the column instead of showing the expression total.

Regards,

Jagan.

topic Expression Total Coming Wrong Due To Using Nested Aggregation in QlikView

Expression Total Coming Wrong Due To Using Nested Aggregation

Re: Expression Total Coming Wrong Due To Using Nested Aggregation

Expression Total Coming Wrong Due To Using Nested Aggregation