topic Range Sum in QlikView

Max of a column

Thu, 22 Apr 2010 10:59:24 GMT

I have this pivot table.

The second columns have the sum of the sales in a day.

and the fourth column must have the max of the salesman.

I'm triing :

IF(Date>=vDateFrom and Date<=vDateTo,rangeMax(above( sum( IF(Date>=vDateFrom and Date<=vDateTo,Sales) ),0, rowno()) ))

and is doing the top of the nums above.. how can i do ???

Thanks

Thu, 22 Apr 2010 11:34:51 GMT

Hi,

view attached file.

Alex

there's some error in file upload .

Thu, 22 Apr 2010 16:48:03 GMT

there's some error in file upload .

sorry if you can upload ... i would thanks!!

Thu, 22 Apr 2010 17:23:24 GMT

hi,

view attached file

Alex

Fri, 23 Apr 2010 08:17:20 GMT

sorry i can´t open

i have 8.01 version

thanks for all.

Fri, 23 Apr 2010 09:48:03 GMT

now i am triing :

max(aggr(sum(ALL <Place,Salesman,Date> IF(date>=vDateFrom and Date<=vDateTo,Sales) ), Place,Salesman,Date))

it is making the max of all the dimension but in the date of the salesman also must appear the max.

Thanks.