topic Re: Experession Help in QlikView

Experession Help

Wed, 03 Feb 2016 14:29:01 GMT

Hi All

I have a the below expression the calculate the sales for branches with a condition to except WEB sales for 7 branches

the values are coming correctly but the totals are not correct i have to use a Pivot table

if(Match(BRANCH,'0001','0021','0031','0041','0051','0061','0071'),

SUM(AGGR((Sum({<MONTH={'$(v1MonthYear)'},WEB-={1}>} SALE)/Sum({<MONTH={'$(v1MonthYear)'}>} WORKINGDAYS)),

BRANCH)),

SUM(AGGR(

(Sum({<MONTH={'$(v1MonthYear)'}>} SALE)/Sum({<MONTH={'$(v1MonthYear)'}>} WORKINGDAYS))

,AREA,BRANCH))

)

Please Suggest

sunny_talwar — Wed, 03 Feb 2016 14:32:21 GMT

Try another Aggr()

Sum(Aggr(If(Match(BRANCH,'0001','0021','0031','0041','0051','0061','0071'),

SUM(AGGR((Sum({<MONTH={'$(v1MonthYear)'},WEB-={1}>} SALE)/Sum({<MONTH={'$(v1MonthYear)'}>} WORKINGDAYS)),

BRANCH)),

SUM(AGGR(

(Sum({<MONTH={'$(v1MonthYear)'}>} SALE)/Sum({<MONTH={'$(v1MonthYear)'}>} WORKINGDAYS))

,AREA,BRANCH))

), YourChartDimensions))

Also if this is in the straight table, make use of Total Mode rather than Aggr() function.

Wed, 03 Feb 2016 14:35:40 GMT

HI Sunny

Thanks it worked

Wed, 03 Feb 2016 14:40:12 GMT

I believe, Partial sums simply sum the rows.